Analytics tables
Note: The Analytics tables are automatically created when using the product or through the migration utility.
Main Tables
RemoteAccess Table: Registers the information relevant to the Thinfinity® Remote Desktop Server user access.
Field |
Description |
RemAccID |
Auto increment field. Unique ID |
AccessTime |
The moment when the user accessed Thinfinity® Remote Desktop Server. |
BrowserID |
Reference to the browser the user accessed with, shown in the Browser table. |
[User] |
Username. |
SourceIP |
IP address that the user logged in from. |
SuccessFul |
1 = successful login, 0 = Error |
Thinfinity® Remote Desktop Server session information
The Thinfinity® Remote Desktop Server session information is stored in two tables with a master/detail relationship.
Sessions Table: Each time a user access a remote server through Thinfinity® Remote Desktop Server an entry in the Sessions table is generated. This entry is updated with the disconnection date when the session ends (by closing the tab or browser).
Field |
Description |
SessionID |
Auto increment field. Unique session ID. |
BrowserID |
Reference to Browsers table indicating which browser did the user start the session with. |
[User] |
Thinfinity® Remote Desktop Server logged in username. |
ConnectedOn |
Date/time of session start. |
DisconnectedOn |
Date/time of session end. If this field has a 'Null' value it means the session is still open. |
EventLogs Table: In this table an entry is generated for each event related to the session referenced by the SessionID field.
Field |
Description |
EventLogID |
Auto increment field. Unique ID. |
SessionID |
Reference to Sessions.SessionID. Shows the session the event belongs to. |
ConnectionID |
Always 0 for Thinfinity® Remote Desktop Server. |
ActionID |
Reference to Actions.ActionID. Shows the action of the event. |
EventTime |
Date/time of the event. |
Message |
Event message. |
Protocol |
Protocol. Such as: UDP, etc. |
RemoteHost |
Remote host, when available. |
Auxiliary Tables
Actions: Fixed list container for actions referenced by the ActionID column in the EventLogs table.
Field |
Description |
ActionID |
Action ID. |
Description |
Action description. |
Browsers: Has a unique list of browsers detected by the product. Any reference in User Agent generates a new entry in the Browsers list. This table is references both by the RemoteAcess table and the Sessions table.
Field |
Description |
BrowserID |
Auto increment field. Unique ID. |
LongDesc |
User Agent. |
ShortDesc |
Short description – CHROME, FIREFOX, etc. |
Version |
Not used for the moment. |