Well... first, technically this isn't supported by TAC.
that said, I'm working on a set of documents that outline the data object model and, after that, a proper data dictionary. the data dictionary wont be complete till post 4.0 release, just too much to do between now and then, however the data object model document is about complete and covers which tables in which databases basic information is stored... it doesn't go into column definitions, however, which can be a bit hairy. This doc along with the architecture overview document I've been working on will show up in the white papers section on the Unity documentation page before the release of Unity 4.0.
If you have specific report needs that you can detail, I can probably just post the snappy SLQ queries you can use to get what you need.
It slices it dices and it has lots of pretty graphs. Should do what you need on that front.
As for the message storage info, we will be releasing the Message Store Manager tool for Unity here in 3 or 4 weeks that will have very detailed message storage usage reports that will slice subscribers or groups of subscribers inbox traffic up in many ways and dump the info out to CSV files for you to chew on. This should get you what you need there, I'll post a message out here when it's available on AnswerMonkey.net
There's no snappy SQL query I can run for you to get the HD information off your box, however.
These reports don't pull their data from SQL (some reports do but not the ones you list here). The storage usage report actually has to talk to the DOH to log into user's mailboxes and get size/limits information for all subscribers (one of the reasons it can take a whiel to run). The port usage data comes from the AvCsMgr data logs under commserver\logs directory.
the database it crunches together ends up in the ReportdDB database in SQL. These are "raw" tables that get converted into HTML or CSV output by the Crystal engine. Not sure if this is what you're looking for or not...
There's currently no mechanism to schedule reports, unfortunately... this was on the feature list for 2 or 3 releases but the resources to do it always got pulled off to work on something considered more critical. This isn't on the short term radar at this point...
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...