Links

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® 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.