Deprecated in:
5.4.019
Log of login attempts, both successful and unsuccessful.
Add row:
Not allowed
Delete row:
Not allowed
Foreign key:
Not allowed
Columns
| Name | Datatype | Read | Write | Primary key | Description |
|---|---|---|---|---|---|
| LoginLogId | int | No | No | Yes | Private. |
| LogDatetime | datetime | Yes | No | No | Time of the login attempt. |
| LoginResultId | tinyint | Yes | No | No | Result of the login attempt. See ADMINLoginResult. |
| UserId | int | Yes | No | No | ID of user that logged in. May contain ID values of users that since have been deleted from ADMINUser. |
| Username | varchar(300) | Yes | No | No |
Name of the user. Either the name entered in the username field or the user's account in the domain. You should only use this column for debugging and never make any assumptions about its contents. |
| IpAddress | varchar(40) | Yes | No | No | The client's IP address. Can be on any format but will in practice either be IPv4 or IPv6. |
| UserAgent | varchar(1000) | Yes | No | No | User agent of client's browser. |
| Https | bit | Yes | No | No | If the client was using HTTPS. |