generate 'Cisco Unified Intelligence Center' reports out of 'Cisco Unified CCX' database tables

[AliHeydari84300]

Hi

In our company, we use cisco agent desktop and cisco ip communicator. We used to log into 'Cisco Unified Intelligence Center' to extract reports like 'Agent Detail Report' and 'Common Skill CSQ Activity Report'.

Recently we have been granted access to 'Cisco Unified CCX' database tables. These tables include 'AgentConnectionDetail', 'ContactCallDetail', 'ContactQueueDetail', 'RtCSQsSummary' and 'Resource'.

My question is how can we generate reports like 'Agent Detail Report' and 'Common Skill CSQ Activity Report' out of 'Cisco Unified CCX' database tables? Does anyone know which tables we should use and join to generate these reports?

Thanks.

[Anusha B R]

hi,

Could you repost this query under contact center - https://community.cisco.com/t5/contact-center/bd-p/j-disc-dev-contact-center

Regards,
Anusha B R