10-28-2015 08:50 AM - edited 03-19-2019 10:17 AM
Using CUC 9.1
I am trying to create a report that lists all the users and their voicemail mailbox size. I have already looked in CUC Serviceability and this is not an option in the reports. I know CUDD is available for this, but that is not an option I have.
I found some SQL commands online that can be run from the CLI, but those did not work either. I tried to run both of the commands that are listed in the 'List All User Mailbox Sizes with Send and Receive Limits' section of the webpage listed below.
Can anyone guide me in a direction so I can get this information?
Thank you
10-28-2015 11:58 AM
Try this
run cuc dbquery unitydirdb select alias as UserID,bytesize,send,receive,
warning from vw_user,unitymbxdb1:vw_mailbox where vw_user.objectid in (select
userobjectid from vw_usermailboxmap where
vw_usermailboxmap.mailboxid=unitymbxdb1:vw_mailbox.mailboxobjectid) order by
bytesize desc
10-28-2015 12:07 PM
I ran (I removed the space breaks between the lines):
run cuc dbquery unitydirdb select alias as UserID,bytesize,send,receive, warning from vw_user,unitymbxdb1:vw_mailbox where vw_user.objectid in (select userobjectid from vw_usermailboxmap where vw_usermailboxmap.mailboxid=unitymbxdb1:vw_mailbox.mailboxobjectid) order by bytesize desc
Output Received:
ACE_File_Lock::ACE_File_Lock: Permission denied /dev/shm/CCM_GENstatusLock_0
General exception error has occurred in the optimizer.
Command failed
10-28-2015 01:13 PM
The command is correct it works fine in my lab. just check syntax, line and space.
or suggest copy in a notepad and make sure there is no space or syntax left behind.
Br,
nadeem
10-29-2015 09:13 AM
When I tried to run the statement you have, it came back with that error message and no results. When I ran the following SQL statement, I did not receive the error and it gave me the list of users. I am not sure why the other command would not work, but at least I found a command that will.
Thank you again!
run cuc dbquery unitymbxdb1 select description, bytesize,send,receive, warning from vw_mailbox where description is not null
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: