KB35811: How to track Subscription deliveries using Statistics Tables in MicroStrategy 10.x?

• Strategy

This document outlines how to track Subscription deliveries using Statistics Tables in MicroStrategy 10.x?

When users are troubleshooting issues related to Distribution Services it is very useful to enable Advance Statistics > Subscription Deliveries at the Project Level. Users can do it from Strategy Desktop > Project Configuration > Statistics > General.

In order to track each delivery being process on the Strategy Intelligence Server, users can track the entries on ‘IS_MESSAGE_STATS’ table. They can refer to 3 main columns to identify the Deliveries: ‘DATATYPE’,’DELIVERYTYPE’ and ‘DELIVERYSTATUS.’

Using ‘DATATYPE’ column, users will be able to identify if the operation is delivering a Document or a Report.

IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed

Using ‘DELIVERYTYPE’ column, users will be able to determine the final destination of the Delivery. Below users can find all the possible values for this column and its definition.

IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed

Using ‘DELIVERYSTATUS’ column, users will be able to determine if the message was successfully delivered.

IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed
IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed	IS_DATATYPE_ID IS_DATATYPE_DESC3REPORT DEFINITION55DOCUMENT DEFINITIONIS_DELIVERY_TYPE_IDIS_DELIVERY_TYPE_DESC1EMAIL2FILE4PRINTER8CUSTOM16INBOX32CLIENT64CACHE128MOBILE256LAST ONE597ALLCOLUMN VALUEDESC0Failed1Succeed

Comment

0 comments

Details

Knowledge Article

Published:

April 5, 2017

Last Updated:

April 5, 2017