MicroStrategy ONE
Statistics on Subscriptions and Deliveries
MicroStrategy's Narrowcast Server product logs statistics about each of the Narrowcast services and subscriptions, under the Transmission Recording component. Similar information is logged as part of the statistics collected for MicroStrategy Distribution Services.
The information is logged in the schedule statistics staging table, STG_IS_MESSAGE_STATS. The Enterprise Manager data load process moves the information to the IS_MESSAGE_STATS table. The details of the information in this staging table are in the Statistics Data Dictionary in the System Administration Help. The table below shows the pertinent Narrowcast Server information and the equivalent information in the Enterprise Manager statistics tables for Distribution Services.
|
Narrowcast Server Service Information Category |
Distribution Services Schedule column names in STG_IS_MESSAGE_STATS and IS_MESSAGE_STATS tables |
|
|
PHYSICALADDRESS |
|
User ID |
RECIPIENTCONTACTID or RECIPIENTCONTACTNAME |
|
Login ID |
Not applicable. All users log in as themselves and use USERID. |
|
Unique Message ID |
Create a unique message ID by combining MESSAGEINDEX with SESSIONID |
|
Subscription Set ID |
SCHEDULEID. The Narrowcast Server concept of a subscription set is a schedule in Distribution Services. |
|
Address ID |
ADDRESSID |
|
Subscription ID |
SUBSINSTID |