All authentication attempts (both successes and failures) are logged in the AuthenticationLog database table. The following are the rows of interest on this table:
Field |
Meaning |
---|---|
timeEntered |
The timestamp of the entry in the log. |
userName |
The username associated with the login attempt. |
altLogin |
Boolean indication of whether the username represents an alternate Login ID. When this column equals '1' (true) the value in the userName column is an alternate login ID as per Alternate Login IDs; otherwise, the userName column represents the userName from the Users or ExternalUser table. |
loginFailures |
The number of login failures for this user since their last successful login. |
lastLogin |
The date and time of the last successful login. |
loginStatus |
The status of the login attempt. This may be one of:
|
The LogAdmin API can be used to query the AuthenticationLog database table. The Java documentation for this class should be referenced for further details.