Perfectly understood. Some customers access the HDS for a number of specialized reports. Customers also export the HDS data to Business Intelligence data stores.
Please download a copy of the ICM Schema document and study the tables.
You will also need to know how the tables work in the AW and HDS - some objects that appear to be tables in the AW are really views into the HDS tables. SQL Enterprise Manager will show you the arrangement.
Cisco caution against querying the tables on a running system during working hours. The safest thing is to export to another machine on a nightly job and play with that. As long as you don't mind being roughly a day behind, this can work.
If you need more timely info and must query the HDS during business hours, you must understand how to query the RCD and TCD tables efficiently because these are not indexed in a way that's suitable for reading - they are designed for high-performance writing. It is easy to call a badly designed query on these tables that can spike the CPU and affect the ICM system.
Having a copy of the DB to experiment in building efficient queries is advisable.
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...