MicroStrategy ONE
STG_IS_MESSAGE_STATS
Records statistics related to sending messages through Distribution Services. 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_MESSAGE_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 job was requested for execution. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|
HOUR_ID |
Hour the job was requested for execution. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
MINUTE_ID |
Minute the job was requested for execution. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
MESSAGEINDEX |
Message GUID used to identify a message. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
SESSIONID |
GUID of the user session created to generate the message. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
HISTORYLISTMESSAGEID |
History List message ID. If there is no History List message associated with the subscription, this value is 00000000 00000000 00000000 00000000. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SCHEDULEJOBID |
Job ID of report/document executed to run the subscription instance. If no job is created, this value is -1. If a fresh job A is created and it hits the cache of an old job B, SCHEDULEJOBID takes the value of the fresh job A. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
DATATYPE |
Type of subscribed object: 3: Report 55: Document |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
RECIPIENTCONTACTID |
GUID of the message recipient. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
DELIVERYTYPE |
Type of subscription: 1: Email 2: File 4: Printer 8: Custom 16: History List 32: Client 40: Cache update 128: Mobile 100: Last one 255: All |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
SUBSINSTID |
Subscription instance GUID used to send the message. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SCHEDULEID |
Schedule GUID. If there is no schedule associated with the subscription, this value is -1. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SUBINSTNAME |
Name of the subscription. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
DATAID |
GUID of the data content. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
CONTACTTYPE |
The contact type for this subscription instance's RecipientID. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
RECIPIENTGROUPID |
Recipient's group ID for group messages sent to a Contact Collection or a User Group. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
RECIPIENTCONTACTNAME |
Name of the contact who received the message. |
VARCHAR (255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
ISDEFAULTADDRESS |
Whether the address that the message was sent to is the default address of a MicroStrategy user: 0: No 1: Yes |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
ADDRESSID |
GUID of the address the message was sent to. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
DEVICEID |
ID of the device the message was sent to. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
ISNOTIFICATIONMESSAGE |
Whether a notification was sent: 0: No 1: Yes |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
NOTIFICATIONADDR |
Address ID the notification is sent to. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
SERVERID |
Server definition GUID under which the subscription ran. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERMACHINE |
Server machine name or IP address under which the report or document job ran. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
PROJECTID |
Project GUID under which the data content resides. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
EXECSTARTTIME |
Time at which the message creation started. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
EXECFINISH TIME |
Time at which the message delivery finished. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
DELIVERYSTATUS |
Status of the message delivery. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
PHYSICALADDRESS |
Email address the message was sent to. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
BATCHID |
|
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
RECORDTIME |
Timestamp of when the record was written to the table. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |