UCCE SQL Queries

[devimohan]

I'm new to the UCCE environment. Any recommendations of where i can get materials on how to generate basic SQL queries for UCCE?

[Ritesh Desai]

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

[DJ Kulkarni]

Hi,

Most important tables in UCCE for troubleshooting are TCD and RCD tables

• The Termination_Call_Detail  table gets a new entry for each call leg that is terminated.
• The Route_Call_Detail table gets a new entry when the call router has completed routing a call.

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

[Muhammad Raza]

check below link.

https://supportforums.cisco.com/t5/collaboration-voice-and-video/cisco-ucce-sql-queries/ta-p/3141482

Thanks,

Raza