Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unity user and system reports.

Status
Not open for further replies.
Jul 13, 2007
131
US
Good afternoon! I've been asking this question around here and everywhere else but I had no luck. I've been looking for some good user/system reports in the Unity system. There are reports in the admin section but they are limited. I was told that the Unity server itself has good reports but I can't verify it. I'm looking for reports like show unused mailboxes. The amount of messages subscribers have and the last time they checked their v-mail. Who's "hiding behind" thier v-mail? Mailboxes that could be hacked and so on.
I've searched everywhere I could and I promise I won't bug you with this issue again.
But again, does the server have reports that might be helpful?
Thanks much!

Frank. City of Cape Coral, Florida
 
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

 
Thanks for the reply. Holy cow that's allot of infromation: Perhaps TMI. Like my name implies ("old time phoneguy") I can remember the legacy systems like NEC, Rolm, Nortel and the like. They had easy to access and easy to read helpful reports. Quickly you could get right to the nuts and bolts information for any or all users. Sorry to rant about the old days but I missed my 10 AM nap.
Thanks again!

Frank. City of Cape Coral, Florida
 
I know how you feel Frank,I am an Old Nortel/Avaya guy myself.
Thanks
Randy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top