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 z/Scope Anywhere Server user access.
Field |
Description |
RemAccID |
Auto increment field. Unique ID |
AccessTime |
The moment when the user accessed z/Scope Anywhere. |
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 |
z/Scope Anywhere Server session information
The z/Scope Anywhere Server session information is stored in two tables with a master/detail relationship.
Sessions Table: Each time a user access a remote server through z/Scope Anywhere 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] |
z/Scope Anywhere Server logged in username. |
SourceIP |
Source IP address. |
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. |
UBRWID |
Unique browser ID. |
Pin |
Session Identifier. |
LastActivity |
Date/time of last activity. |
TermConnections Table: In this table an entry is generated for each connection started.
Field |
Description |
TermConnectionID |
Auto increment field. Unique ID. |
SessionID |
Reference to Sessions.SessionID. Shows the session the event belongs to. |
ConnectionID |
Reference to the Connection that performs the action. The value can be NULL (server start or any other server action) or a number (terminal action). |
Protocol |
Protocol used for the connection. |
RemoteHost |
Destination host name. |
ProfileID |
Connection profile's ID. |
Address |
Destination host address. |
Connected |
Date/time of connection start. |
Disconnected |
Date/time of session end. If this field has a NULL value it means the connection is still open. |
LastActivity |
Date/time of last activity. |
Removed |
Indicates if the connection was removed from Anaylitics. |
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 |
Reference to the Connection that performs the action. The value can be NULL (server start or any other server action) or a number (terminal action). |
ActionID |
Reference to Actions.ActionID. Shows the action of the event. |
EventTime |
Date/time of the event. |
Message |
A textual description for the event. |
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 referenced both by the RemoteAccess 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. |