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