MicroStrategy ONE
STG_CT_DEVICE_STATS
Records statistics related to the mobile client and the mobile device. 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_DEVICE_STATS table, which has the same columns and datatypes.
| Column | Description | SQL Server Datatype | Oracle Datatype | DB2 Datatype | Teradata Datatype | Sybase Datatype | MySQL Datatype |
|
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 |
|
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 Intelligence Server processing the request. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
DEVICEINSTID |
Unique installation ID of the mobile app. |
CHAR(40) |
CHAR(40) |
CHAR(40) |
CHAR(40) |
CHAR(40) |
CHAR(40) |
|
DEVICETYPE |
Type of device the app is installed on, such as iPad, Droid, or iPhone. |
VARCHAR(40) |
VARCHAR2(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
|
OS |
Operating system of the device the app is installed on, such as iOS or Android. |
VARCHAR(40) |
VARCHAR2(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
|
OSVER |
Version of the operating system, such as 5.2.1. |
VARCHAR(40) |
VARCHAR2(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
|
APPVER |
Version of the MicroStrategy app. |
VARCHAR(40) |
VARCHAR2(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
VARCHAR(40) |
|
STATECOUNTER |
An integer value that increments whenever the device information, such as DEVICETYPE, OS, OSVER, or APPVER, changes. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
STATECHANGETIME |
Date and time when STATECOUNTER is incremented. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
RECORDTIME |
Timestamp of when the record was written to the database, according to database system time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |