11-01-2016 09:55 PM - edited 03-17-2019 08:33 AM
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
Solved! Go to Solution.
11-01-2016 10:14 PM
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)
11-01-2016 10:14 PM
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)
11-02-2016 03:17 AM
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
11-02-2016 06:05 AM
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
Cheers!
Rob
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide