12-24-2015 06:59 AM - edited 03-14-2019 03:35 PM
I'm new to the UCCE environment. Any recommendations of where i can get materials on how to generate basic SQL queries for UCCE?
12-26-2015 02:51 AM
Hi devimohan,
There are no materials guiding you how to generate SQL queries for UCCE. You need to be sound of SQL to execute queries. What you can do is, Go to SQL DB for UCCE. You can refer the UCCE tables and refer Cisco Guides to understand the table definitions.
regards,
Ritesh Desai
12-27-2015 07:44 PM
Hi,
Most important tables in UCCE for troubleshooting are TCD and RCD tables
If you want to see what all has been configured in AW like number of agents,skill groups,call types etc then below tables can be accessed for SQL selecting awdb
t_Agent
t_SkillGroup
t_Call Type
Some examples for reference
select * from Router_Call_Detail where DateTime between ‘2015-12-27 00:00:00’ and ‘2015-12-27 23:59:59’
select * from Termination_Call_Detail where DateTime between ‘2015-12-27 00:00:00’ and ‘2015-12-27 23:59:59’
Select * from Call_Type where EnterpriseName like ‘abc%’
There is already a very good link in support forum explaining TCD and RCD please refer
https://supportforums.cisco.com/document/63806/using-termination-call-detail-and-route-call-detail-records-troubleshooting
Regards,
DJ
03-12-2018 06:35 AM
check below link.
https://supportforums.cisco.com/t5/collaboration-voice-and-video/cisco-ucce-sql-queries/ta-p/3141482
Thanks,
Raza
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide