Database Reference
The UserLock database is composed of two tables:
- The 'UserLogonEvents' table to record session events,
- The 'UserStatus' table to record 'User status'.
You can find below a list of the fields including in these tables, showing their type and their purpose.
Please note: The UserLock database is in free access to benefit from all data generated and collected by UserLock. However we strongly recommend that neither the database architecture nor content information be modified.
UserLogonEvents table
UserStatus table
Field name |
Data type |
Field description |
Id |
integer |
Record id (auto) |
Status |
integer |
Current
status of the user: |
Triggers |
integer |
Flags
of remarkable conditions to help deduce the current status for
the user. |
OldStatus |
integer |
Previous
status of the user: |
OldTriggers |
integer |
Flags
of remarkable conditions to help deduce the previous status for
the user. |
UserAccount |
string |
User account name |
UserDomain |
string |
User domain |
UserFullName |
string |
User full name |
SessionId |
string |
Session identifier |
SubSessionId |
string |
Sub session identifier. Increased by 1 after each unlock event (new subsession) |
EventType |
integer |
Interactive sessions
|
EventTime |
date time |
Date and time of the logon/logoff event |