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

Email

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