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.
Regards,
Geoff
