Subscriber Message Store Status Dump
The Subscriber Message Store Status Dump generates a CSV file with data about each included subscriber’s mailbox. This data is extensive and detailed and is intended to for analysis using a tool like Microsoft Excel or a database management tool.
Reports are dumped to a file based on the name of the Agent, and the time the report generation began. For example, the file name for a report for the “Sales” agent might look like:
Sales_MailboxDump_021002_091437.csv
Report files can be found in the TEMP folder of the user account used to run the report – by default the user that runs the MSM Console.
The first line of the file is a header with column titles for all of the fields in the CSV file. They are:
Column
Type
Description
ALIAS
Text
Subscriber’s alias
EXTENSION
Text
Subscriber’s DTMF access ID, or extension
WARNINGLIMIT
KB
Capacity of message box before warnings are generated
SENDLIMIT
KB
Capacity of message box before sending messages is prohibited
SENDRECEIVELIMIT
KB
Absolute maximum size of message box
SENDLIMITEXCEEDED
Boolean
1 if WARNING limit exceeded, 0 otherwise
SENDRECEIVELIMITEXCEEDED
Boolean
1 if SENDLIMIT exceeded, 0 otherwise
TOTALCOUNT
Count
Count of all messages in message box
TOTALSIZE
KB
Size of all messages in message box
TOTALREADCOUNT
Count
Count of read/heard messages in message box
TOTALREADSIZE
KB
Size of read/heard messages in message box
TOTALUNREADCOUNT
Count
Count of unread/unheard messages in message box
TOTALUNREADSIZE
KB
Size of unread/unheard messages in message box
VOICECOUNT
Count
Count of all voice messages in message box
VOICESIZE
KB
Size of all voice messages in message box
VOICEREADCOUNT
Count
Count of read/heard voice messages in message box
VOICEREADSIZE
KB
Size of read/heard voice messages in message box
VOICEUNREADCOUNT
Count
Count of unread/unheard voice messages in message box
VOICEUNREADSIZE
KB
Size of unread/unheard voice messages in message box
FAXCOUNT
Count
Count of all fax messages in message box
FAXSIZE
KB
Size of all fax messages in message box
FAXREADCOUNT
Count
Count of read/heard fax messages in message box
FAXREADSIZE
KB
Size of read/heard fax messages in message box
FAXUNREADCOUNT
Count
Count of unread/unheard fax messages in message box
FAXUNREADSIZE
KB
Size of unread/unheard fax messages in message box
RECEIPTCOUNT
Count
Count of all receipts in message box
RECEIPTSIZE
KB
Size of all receipts in message box
RECEIPTREADCOUNT
Count
Count of read/heard receipts in message box
RECEIPTREADSIZE
KB
Size of read/heard receipts in message box
RECEIPTUNREADCOUNT
Count
Count of unread/unheard receipts in message box
RECEIPTUNREADSIZE
KB
Size of unread/unheard receipts in message box
OTHERCOUNT
Count
Count of all other messages in message box
OTHERSIZE
KB
Size of all other messages in message box
OTHERREADCOUNT
Count
Count of read/heard other messages in message box
OTHERREADSIZE
KB
Size of read/heard other messages in message box
OTHERUNREADCOUNT
Count
Count of unread/unheard other messages in message box
OTHERUNREADSIZE
KB
Size of unread/unheard other messages in message box
INBOXCOUNT
Count
Count of all messages in Inbox
INBOXSIZE
KB
Size of all messages in Inbox
INBOXREADCOUNT
Count
Count of read/heard messages in Inbox
INBOXREADSIZE
KB
Size of read/heard messages in Inbox
INBOXUNREADCOUNT
Count
Count of unread/unheard messages in Inbox
INBOXUNREADSIZE
KB
Size of unread/unheard messages in Inbox
DELETEDCOUNT
Count
Count of all messages in Deleted Items folder
DELETEDSIZE
KB
Size of all messages in Deleted Items folder
DELETEDREADCOUNT
Count
Count of read/heard messages in Deleted Items folder
DELETEDREADSIZE
KB
Size of read/heard messages in Deleted Items folder
DELETEDUNREADCOUNT
Count
Count of unread/unheard messages in Deleted Items folder
DELETEDUNREADSIZE
KB
Size of unread/unheard messages in Deleted Items folder
SENTCOUNT
Count
Count of all messages in Sent Items folder
SENTSIZE
KB
Size of all messages in Sent Items folder
SENTREADCOUNT
Count
Count of read/heard messages in Sent Items folder
SENTREADSIZE
KB
Size of read/heard messages in Sent Items folder
SENTUNREADCOUNT
Count
Count of unread/unheard messages in Sent Items folder
SENTUNREADSIZE
KB
Size of unread/unheard messages in Sent Items folder
DUMPSTERCOUNT
Count
Count of all messages in Unity Dumpster
DUMPSTERSIZE
KB
Size of all messages in Unity Dumpster
DUMPSTERREADCOUNT
Count
Count of read/heard messages in Unity Dumpster
DUMPSTERREADSIZE
KB
Size of read/heard messages in Unity Dumpster
DUMPSTERUNREADCOUNT
Count
Count of unread/unheard messages in Unity Dumpster
DUMPSTERUNREADSIZE
KB
Size of unread/unheard messages in Unity Dumpster
VOICE1DAY
Count
Number of voice messages arriving today
VOICE2DAY
Count
Number of voice messages arriving yesterday
VOICE3DAY
Count
Number of voice messages arriving 2 days ago
VOICE4DAY
Count
Number of voice messages arriving 3 days ago
VOICE5DAY
Count
Number of voice messages arriving 4 days ago
VOICE6DAY
Count
Number of voice messages arriving 5 days ago
VOICE7DAY
Count
Number of voice messages arriving 6 days ago
VOICE14DAY
Count
Number of voice messages arriving 7 to 13 days ago
VOICE21DAY
Count
Number of voice messages arriving 14 to 20 days ago
VOICE28DAY
Count
Number of voice messages arriving 21 to 27 days ago
VOICEMAXDAY
Count
Number of voice messages arriving 28 days ago or longer
FAX1DAY
Count
Number of fax messages arriving today
FAX2DAY
Count
Number of fax messages arriving yesterday
FAX3DAY
Count
Number of fax messages arriving 2 days ago
FAX4DAY
Count
Number of fax messages arriving 3 days ago
FAX5DAY
Count
Number of fax messages arriving 4 days ago
FAX6DAY
Count
Number of fax messages arriving 5 days ago
FAX7DAY
Count
Number of fax messages arriving 6 days ago
FAX14DAY
Count
Number of fax messages arriving 7 to 13 days ago
FAX21DAY
Count
Number of fax messages arriving 14 to 20 days ago
FAX28DAY
Count
Number of fax messages arriving 21 to 27 days ago
FAXMAXDAY
Count
Number of fax messages arriving 28 days ago or longer
RECEIPT1DAY
Count
Number of receipts arriving today
RECEIPT2DAY
Count
Number of receipts arriving yesterday
RECEIPT3DAY
Count
Number of receipts arriving 2 days ago
RECEIPT4DAY
Count
Number of receipts arriving 3 days ago
RECEIPT5DAY
Count
Number of receipts arriving 4 days ago
RECEIPT6DAY
Count
Number of receipts arriving 5 days ago
RECEIPT7DAY
Count
Number of receipts arriving 6 days ago
RECEIPT14DAY
Count
Number of receipts arriving 7 to 13 days ago
RECEIPT21DAY
Count
Number of receipts arriving 14 to 20 days ago
RECEIPT28DAY
Count
Number of receipts arriving 21 to 27 days ago
RECEIPTMAXDAY
Count
Number of receipts arriving 28 days ago or longer
OTHER1DAY
Count
Number of other messages arriving today
OTHER2DAY
Count
Number of other messages arriving yesterday
OTHER3DAY
Count
Number of other messages arriving 2 days ago
OTHER4DAY
Count
Number of other messages arriving 3 days ago
OTHER5DAY
Count
Number of other messages arriving 4 days ago
OTHER6DAY
Count
Number of other messages arriving 5 days ago
OTHER7DAY
Count
Number of other messages arriving 6 days ago
OTHER14DAY
Count
Number of other messages arriving 7 to 13 days ago
OTHER21DAY
Count
Number of other messages arriving 14 to 20 days ago
OTHER28DAY
Count
Number of other messages arriving 21 to 27 days ago
OTHERMAXDAY
Count
Number of other messages arriving 28 days ago or longer
VM Mailbox Rule
Boolean
1 if VM mailbox rule exists, 0 otherwise