Cisco unity connection user voice message status

[s.maxina1]

Hi All 

i have a cisco unity connection version 10.5.1.10000-7. I need to get information about each user mailbox message include total message, read messages and deleted messages. I need this from cli use “run cuc dbquery “ commnad. Can somebody help me the right command?

best regards 

Sina Hr

[Maren Mahoney]

There are CLI commands that can provide the information you are looking for, but I would encourage you to use the User Data Dump from ciscounitytools.com instead. The tool allows you to customize the data gathered along with the set of users you are interested in. Note that you will need to install the ODBC drivers (information and link with the User Data Dump), but once installed allows you to use a great many of the tools.

On the User Data Dump tool page, click on Tool Help to get a step-by-step guide for using the tool. Let us know if you have questions.

Maren

[s.maxina1]

Thanks for reply. I know that tools. But at this time i need cli commnad.

[Maren Mahoney · Accepted solution]

Try this:

run cuc dbquery unitymbxdb1 select alias as UserID, count (*) as TotalMessages, sum(case when deleted='0' then 1 else 0 end) as Inbox, sum(case when seen='1' then 1 else 0 end) as Seen, sum(case when deleted='1' then 1 else 0 end) as Deleted,  min (arrivaltime) as OldestMessageTime, vw_mailbox.bytesize from vw_message, vw_mailbox, unitydirdb:vw_mailbox, unitydirdb:vw_user where vw_message.mailboxobjectid=vw_mailbox.mailboxobjectid and vw_mailbox.mailboxobjectid in (select mailboxid from vw_mailbox where unitydirdb:vw_user.objectid = unitydirdb:vw_mailbox.userobjectid) group by alias, vw_mailbox.bytesize order by TotalMessages desc

Note that this has to be run against each mailstore. It also includes the date of the oldest message in the mailbox along with the total size in bytes.

Maren

[s.maxina1]

Nice command. Its work. Only in below “Read” is forgotten. (as Read)

thanks.

sum(case when seen='1' then 1 else 0 end) as

[Maren Mahoney]

Fixed. If you want to name the column from "Seen" to "Read" change the name at the end of that part of the string.

Maren