Unity Connection 7.1 5, how do we check the end user vmail box size?

[victoriabardy]

Hello All,

Back in the days of windows we had our exchange vmail mesage store that we could login to and look at each end users voicemail account and determine the size of the box.  We are about to enstate voicemail quotas but we are trying to figure out who our major offenders are for keeping voicemail messages way past when they should.

Is there any way to go into the Unity Connection server and look at all of the voicmail boxes in our current Linux build Unity Connection server?  We have a publisher and subscriber here.

If you know, please share!

Thanks again.

Rgds,

Vicky

[Rob Huffman]

Hi Vicky,

Hope all is well with you

You'll want to use this Tool from the great suite of Unity/Unity Connection Tools you can include

the mailbox size in the report you generate;

Connection User Data Dump (CUDD) Tool

The Connection User Data Dump (CUDD) is a Windows-based remote database administration tool available on the Cisco Unity Tools website. CUDD allows you to export specific information about users to a file that can be viewed or imported into another application, such as a database utility or Microsoft Excel. When the data is exported, the tool automatically creates a header row that lists the data type found in each column of the output, for ease of import into other programs.

The tool is available from the "Superb" Unity Tools site;

http://www.ciscounitytools.com/Applications/CxN/UserDataDump/UserDataDump.html

From the Help Notes;

Requirements/Special Notes

This version of User Data Dump runs on Windows XP/2000/2003 or Vista.

***This version of User Data Dump only works with Unity Connection 7.0(1) or later.

You must enable the ODBC proxy service on the Unity Connection server and attach to the database using an account enabled for the remote database access role. See the next section for details on this.

http://www.ciscounitytools.com/Applications/CxN/UserDataDump/Help/UserDataDump.htm

Cheers!
Rob

[victoriabardy]

Hey there Rob,

This is great, we didn't know about this tool.  If we turn the ODBC Proxy service on (currently disabled) can we do that during production hours?  Is there any database impact, like higher CPU utilization?  We have a primary and secondary unity cluster, just want to figure out if there are any precautions we need to take here.  We were looking at DRS Message Fisher because with that application we can go through our back up and there is no impact on production, but its time consuming because you need to go through the mailboxes one by one.

Back to my question, can we turn this on and use the tool during production?

Please let me know.  And thank you again!!

Rgds,

Vicky

[Rob Huffman]

Hey Vicky,

We have used this and other tools like CUDD during

office hours many times without any impact

One thing we have found to be useful is to deactivate the Connection Database Proxy service

when not in use. If you leave it just "stopped" we get a ton of errors in RTMT/syslog (at least in 7.1(3))

Cheers!

Rob