aioc.t_user_auth_log
Table where the logs are saved when trying to log in to the interface.
Column | Data Type | Description |
|---|---|---|
Id | character varying(255) | Authentication id |
user_id | character varying(255) | If the entered user name matches an id in the user table, its id is returned. If not, the username information entered in the interface is logged here |
log_time | timestamp | Time of log in attempt |
event | integer | Allows 1/0 entries. 1 means unsuccessful, 0 means successful. |
event_source | character varying(255) | Event source for the authentication log like ui, api, tacac |
client_ip | character varying(255) | Source ip that sends auth request |
params | character varying(255) | Stores information about the connection. For example, for an incorrect username information, an input such as "No such user X" is stored here |
nas_ip | character varying(255) | The IP address of the target device |
nas_hostname | character varying(255) | The IP hostname of the target device |
user_eid | character varying(255) | User name entered in the interface |
instance_name | character varying(255) | Name of the application started by the server |
db_id | bigint | Table's primary id |