cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
948
Views
0
Helpful
3
Replies

how to see users that have reached their quota on Unity Connection?

Hi all,

Can you tell me how to see the number of users that have reached their quota on Unity Connection (voicemal quota)?

Is there any SQL request (CLI), by GUI (Webadmin) or by RTMT to check?

Thanks a lot for your help.

BR

Aubert

1 Accepted Solution

Accepted Solutions

Aseem Anand
Cisco Employee
Cisco Employee

Hi,

You can try the below command to get this list of 5 mailboxes in the order with decreasing size:

run cuc dbquery unitymbxdb1 select first 5 bytesize,description from vw_mailbox order by bytesize desc

bytesize description
-------- ----------------------------
317003 undeliverablemessagesmailbox
94229 Aseem
59580 test89
0 operator
0 Hello

Aseem

(Please rate if useful)

View solution in original post

3 Replies 3

Aseem Anand
Cisco Employee
Cisco Employee

Hi,

You can try the below command to get this list of 5 mailboxes in the order with decreasing size:

run cuc dbquery unitymbxdb1 select first 5 bytesize,description from vw_mailbox order by bytesize desc

bytesize description
-------- ----------------------------
317003 undeliverablemessagesmailbox
94229 Aseem
59580 test89
0 operator
0 Hello

Aseem

(Please rate if useful)

Hi Aseem,

thanks a lot for your email.

Do you have an other SQL request to display the voicemail size, number of messages by user?

Thanks a lot for your help.

BR

Aubert

Rob Huffman
Hall of Fame
Hall of Fame

Hi Aubert,

Another useful tool for these type of inquiries is CUDD (Cisco User Data Dump) from the great set of Unity Tools put out by Cisco. Here are just some of the available outputs you can get that would relate to your search;

http://ciscounitytools.com/Applications/CxN/UserDataDump/Help/UserDataDump.htm#_Toc359835396

  • Mailbox Send Quota (in bytes).  Maximum number of bytes the user can have in their inbox before they will no longer be allowed to send new voicemail messages.
  • Mailbox Send/Receive Quota (in bytes).  Maximum number of bytes the user can have in their inbox before they will not longer be allowed to send or receive voicemail messages.
  • Mailbox size (in bytes).  Total size in bytes of all messages in the users inbox.
  • Mailbox unread message count.  The total number of messages that are marked unread (new) in the user’s inbox.
  • Mailbox unread secure message count.  The total number of secure messages that are marked unread (new) in the user’s inbox.
  • Mailbox read messages older than 7 days.  The number of messages currently in the users’ mailbox that are read (saved) and arrived 7 days ago or more.  NOTE: This requires that the time of the local client and the time of the Connection server be in agreement (they do not need to be in the same time zone, of course). 
  • Mailbox deleted message count.  The total number of deleted messages in the user’s inbox.  This applies only if the user is associated with a Class of Service that copies deleted messages into the deleted items folder instead of immediately purging them.
  • Mailbox Warning Quota (in bytes).  Maximum number of bytes the user can have in their inbox before they will start getting a warning each time they log in that their mailbox is “almost full”

Cheers!

Rob