MicroStrategy ONE
STG_IS_SESSION_STATS
Logs every Intelligence Server user session. This table is used when the Basic Statistics option is selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_SESSION_STATS table, which has the same columns and datatypes.
The STG_IS_SESSION_STATS table does not contain project-level information and is therefore not affected by statistics purges at the project level. For details about statistics purges, see the System Administration Help.
| Column | Description | SQL Server Data-type | Oracle Data-type | DB2 Data-type | Teradata Data-type | Sybase Data-type | MySQL Data-type |
|
DAY_ID |
Day the session was started. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|
HOUR_ID |
Hour the session was started. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
MINUTE_ID |
Minute the session was started. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
SESSIONID (I) |
GUID of the user session. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERID |
Server definition GUID. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERMACHINE |
(Server machine name:port number) pair. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
USERID |
GUID of the user. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CLIENTMACHINE |
Client machine name, or IP address if the machine name is not available. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
EVENTSOURCE |
Source from which the session originated: 0: Unknown 1: Developer 2: Intelligence Server Administrator 3: Web Administrator 4: Intelligence Server 5: Project Upgrade 6: Web 7: Scheduler 8: Custom Application 9: Narrowcast Server 10: Object Manager 11: ODBO Provider 12: ODBO Cube Designer 13: Command Manager 14: Enterprise Manager 15: Command Line Interface 16: Project Builder 17: Configuration Wizard 18: MD Scan 19: Cache Utility 20: Fire Event 21: MicroStrategy Java admin clients 22: MicroStrategy Web Services 23: MicroStrategy Office 24: MicroStrategy Tools 25: Portal Server 26: Integrity Manager 27: Metadata Update 28: Reserved for MicroStrategy use 29: Scheduler for Mobile 30: Repository Translation Wizard 31: Health Center 32: Cube Advisor 33: Operations Manager 34: Desktop 35: Library 36: Library iOS 37: Workstation 39: Library Android |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
RECORDTIME (I) |
Timestamp of when the record was logged in the database, according to database system time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
WEBMACHINE |
Web server machine from which a web session originates. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
CONNECTTIME (I) |
Timestamp of when the session is opened. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
DISCONNECTTIME |
Timestamp of when the session is closed. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |