Analytics Tables Reference

Top  Previous  Next

 

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.