MicroStrategy ONE
STG_CT_EXEC_STATS
Records statistics related to execution of reports/documents in a mobile app. This table is used when the Mobile Clients option is selected in the Statistics category of the Project Configuration Editor and the mobile client is configured to log statistics. The data load process moves this table's information to the CT_EXEC_STATS table, which has the same columns and datatypes.
| 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 action was started. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|
HOUR_ID |
Hour the action was started. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
MINUTE_ID |
Minute the action was started. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
DEVICEINSTID (I) |
Unique installation ID of the mobile app. |
CHAR(40) |
CHAR(40) |
CHAR(40) |
CHAR(40) |
CHAR(40) |
CHAR(40) |
|
STATECOUNTER (I) |
An integer value that increments when the device information, such as DEVICETYPE, OS, OSVER, or APPVER (in STG_CT_DEVICE_STATS), changes. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
USERID |
GUID of the user making the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SESSIONID |
GUID of the session that executed the request. This should be the same as the SESSIONID for this request in STG_IS_REPORT_STATS. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CTSESSIONID |
GUID of the MicroStrategy Mobile client session ID. A new client session ID is generated every time a user logs in to the mobile app. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
MESSAGEID |
ID corresponding to the JOBID (in STG_IS_REPORT_STATS) of the message generated by the execution. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
ACTIONID |
Similar to JOBID but generated by the client and cannot be NULL. The JOBID may be NULL if the user is offline during execution. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
SERVERID |
GUID of the Intelligence Server processing the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERMACHINE |
Name of the machine hosting the Intelligence Server processing the request. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
REPORTID |
GUID of the report used in the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
DOCUMENTID |
GUID of the document used in the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
PROJECTID |
GUID of the project. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
MSERVERMACHINE |
Name of the load balancing machine. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
CTREQUESTTIME |
Time when the user submits a request to the mobile app. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
CTRECEIVEDTIME |
Time when the mobile app begins receiving data from MicroStrategy Mobile Server. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
CTREQRECTIME |
Difference between CTRequestTime and CTReceivedTime, in milliseconds. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CTRENDERSTARTTIME |
Time when the mobile app begins rendering. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
CTRENDERFINISHTIME |
Time when the mobile app finishes rendering. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
CTRENDERTIME |
Difference between CTRenderStartTime and CTRenderFinishTime, in milliseconds. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
EXECUTIONTYPE |
Type of report/document execution: 1: User execution 2: Pre-cached execution 3: Application recovery execution 4: Subscription cache pre-loading execution 5: Transaction subsequent action execution 6: Report queue execution 7: Report queue recall execution 8: Back button execution |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
CACHEIND |
Whether a cache was hit during the execution, and if so, what type of cache hit occurred: 0: No cache hit 1: Intelligence Server cache hit 2: Device cache hit 6: Application memory cache hit |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
PROMPTIND |
Whether the report or document is prompted: 0: Not prompted 1: Prompted |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
CTDATATYPE |
Whether the job is for a report or a document: 3: Report 55: Document |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
CTNETWORKTYPE |
The type of network used: 3G WiFi LTE 4G |
VARCHAR(40) |
VARCHAR2(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
|
CTBANDWIDTH |
Estimated network bandwidth, in kbps. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
VIEWFINISHTIME |
Time at which the user either clicks on another report/document, or navigates away from the mobile app. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
VIEWTIME |
Difference between CTRenderFinishTime and ViewFinishTime, in milliseconds. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
MANIPULATIONS |
An integer value that increases with every manipulation the user makes after the report/document is rendered, excluding those that require fetching more data from Intelligence Server and/or result in another report/document execution. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
CTAVGMANIPRENDERTIME |
Average rendering time for each manipulation. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CTLATITUDE |
Latitude of the user. |
FLOAT |
FLOAT |
DOUBLE |
FLOAT |
FLOAT |
FLOAT |
|
CTLONGITUDE |
Longitude of the user. |
FLOAT |
FLOAT |
DOUBLE |
FLOAT |
FLOAT |
FLOAT |