Call Data location

Unanswered Question
Sep 4th, 2008
User Badges:

Basically what I am after is; how is the call data stored? I have someone asking if they can get the call data exported so they can run custom reports on it?


CRS 4.0(4)SR_01_Build029

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Jonathan Schulenberg Mon, 09/08/2008 - 18:19
User Badges:
  • Super Bronze, 10000 points or more
  • Cisco Designated VIP,

    2017 IP Telephony

What call data are you referring too? If it is Enterprise Data there are ten, and only ten, values that are stored to the historical reporting database. These are fields 231 through 240.


Enterprise Data and how to configured it within Desktop Administrator is outlined within the Cisco Desktop Administrator User's Guide 6.4 for Unified CM starting on page 25.

http://cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_5_0/user/cda/cda64ug.pdf


Once the data exists within dba_cra, you can report on it as you would normally mine data out. If there is not a standard Historical Report for what you seek, you can create a custom one or replicate the data off-box to a reporting engine of your choosing.

Cisco CRS Historical Reports User Guide 5.0(1): http://cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_5_0/user/hr/crs501hr.pdf

Cisco CRS Database Schema 5.0(1): http://cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_5_0/user/db_schema/crs501ds.pdf

Cisco CRS Historical Reporting Administrator and Developer Guide, 5.0(1): http://cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_5_0/programming/hr_admin_devp/crs501hd.pdf

Actions

This Discussion