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.