ADMINLoginLog

 Show all Hide all
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.