---
title: aioc.t_user_auth_log
slug: kronpam-how-to-guides-180/aioctuserauthlog
description: Learn about the data types and column descriptions in a log table documenting login attempts to an interface. Find information such as authentication and user IDs, login time, success or failure status, event source, client IP, connection details, target 
docTags: 
createdAt: 2022-08-18T16:23:50.000Z
---

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                                                                                                                                     |