Analytics Tables Reference
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® Workspace user access.
Field | Description |
RemAccID | Auto increment field. Unique ID |
AccessTime | The moment when the user accessed Thinfinity® Workspace. |
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® Workspace session information
The Thinfinity® Workspace session information is stored in two tables with a master/detail relationship.
Sessions Table: Each time a user access a remote server through Thinfinity® Workspace 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® Workspace 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® Workspace. |
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. |
Last modified 1yr ago