MicroStrategy ONE
STG_IS_INBOX_ACT_STATS
Records statistics related to History List manipulations. This table is used when the Inbox Messages option is selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_INBOX_ACT_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 (I) |
Day the manipulation was started. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|
HOUR_ID |
Hour the manipulation was started. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
MINUTE_ID |
Minute the manipulation was started. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
SESSIONID (I) |
GUID of the session that started the History List manipulation. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERID |
GUID of the server definition of the Intelligence Server being manipulated. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERMACHINE |
Name and port number of the Intelligence Server machine where the manipulation is taking place. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
PROJECTID |
GUID of the project where the History List message is mapped. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
INBOXACTION |
Type of manipulation: 0: Reserved for MicroStrategy use 1: Add: Add message to History List 2: Remove: Remove message from History List 3: Rename: Rename message 4: Execute: Execute contents of message 5: Change Status: Change message status from Ready to Read 6: Requested: Retrieve message contents 7: Batch Remove: Intelligence Server bulk operation, such as cache expiration |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
USERID |
ID of the user doing the manipulation. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
OWNERID |
ID of the user that created the message. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
MESSAGEID |
GUID of the History List message being acted on. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
MESSAGETITLE |
Name of the report or document referenced in the History List message. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
MESSAGEDISPNAME |
User-defined name of the History List message. Blank unless the user has renamed the History List message. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
CREATIONTIME |
Date and time when the History List message was created. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
STARTTIME |
Date and time when the manipulation started. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
REPORTJOBID (I) |
Report job ID for the History List Message Content Request. Blank if no job was executed or if a document was executed. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
DOCUMENTJOBID (I) |
Document job ID for the History List Message Content Request. Blank if no job was executed or if a report was executed. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
SUBSCRIPTIONID |
ID of the subscription that invoked the manipulation. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
ACTIONCOMMENT |
If the manipulation is a batch deletion of History List messages, this field contains the condition or SQL statement used to delete the messages. If there is an error, this field holds the error message. |
VARCHAR(4000) |
VARCHAR2(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
RECORDTIME |
Timestamp of when the record was written to the database, according to database system time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |