cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
4927
Views
0
Helpful
3
Replies

UCCE SQL Queries

devimohan
Level 1
Level 1

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

3 Replies 3

Ritesh Desai
Spotlight
Spotlight

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

*** Please rate helpful post. Please mark as answer if it solves your problem/query.
regards, Ritesh Desai

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: