Database Reference
The UserLock database is composed of four tables:
- The 'UserLogonEvents' table to record session events,
- The 'UserStatus' table to record 'User status'.
- The 'AdminActions' table to record administrator actions
- The 'AdminActionResults' table to record results related to administrator actions
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 |
AdminActions
Field name |
Data type |
Field description |
Id |
integer |
Record id (auto) |
ServerName |
string |
Server name |
Kind |
integer |
|
Action |
integer |
|
DateStart |
date time |
Date time when admin action started |
DateEnd |
date time |
Date time when admin action started |
UserAccount |
string |
User account name initiating the action |
Priority |
integer |
|
Severity |
integer |
|
DisplayState |
integer |
|
UserAccountFullName |
string |
User account full name initiating the action |
Domain |
string |
Domain name |
AdminActionResults
Field name |
Data type |
Field description |
Id |
integer |
Record id (auto) |
ServerName |
string |
Server name |
AdminActionId |
integer |
AdminAction identifier |
Item |
string |
The setting changed by the admin action |
Param1 |
string |
Dynamic fields |
Param2 |
string |
Dynamic fields |
Param3 |
string |
Dynamic fields |
Param4 |
string |
Dynamic fields |
Param5 |
string |
Dynamic fields |
Param6 |
string |
Dynamic fields |
StateResult |
integer |
|
Details |
string |
Details about the admin action |