UCCX 7.x Historical Reports

[ciscomanii]

I want to create customized reports based on the various reports , tables and fields produced from the UCCX 7.x  Historical reports Application-

Can anyone tell me where the DB and tables are located that generate the reports found in the Historical Application ?

[tim.moomaw]

You can get a general idea by looking SQL statements in the .xml files under C:\Program Files\Cisco UCCX Historical Reports\ReportTemplates\ but the database is db_cra.

[ankitaja]

Please refr to the guide below to see how to create custom reports and

the DB schema for that.

DB Schema:

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_cente

r/crs/express_7_0/user/guide/uccx70dbschema.pdf

Refer to pg 191 for custom historical reporting:

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_cente

r/crs/express_7_0/programming/guide/uccx70hradmdev.pdf