Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Query UCCX database for calls from a specific Caller ID

Hi,

I did some searching and could not find this answer specifically.

I have a request from the call center supervisor to provide a report of all calls coming into the CSQ's showing all of the important data (date, time, answered, not answered, length of call, disposition, etc.) for calls from a specific caller ID for a specific date range.

The caller ID starts with 9XX-XXX-XXXX, so of course UCCX Historical Reports will not display this number as a parameter in the Detailed Call by Call CCDR report because I am limited to the first 32,765 rows. I tried modifying the XML file but have not been successful.

I tried doing a query through the CLI but not sure if I have the query right.

Any insight?

Thank you very much.

2 REPLIES
New Member

Query UCCX database for calls from a specific Caller ID

I tried modifying the XML file for the Detailed Call CSQ Agent report

ICD_Detailed_Call_CSQ_Agent_en_us.xml with the following:

BEFORE:

SELECT distinct callednumber FROM contactcalldetail

AFTER:

SELECT SKIP 10000 FIRST distinct 20000 callednumber FROM contactcalldetail

Unfortunately, there are no changes in the available parameters shown:

Top.jpg

Bottom.jpg

The number starts with a '9', so I need to skip the numbers that start with 408. Any help?

New Member

Query UCCX database for calls from a specific Caller ID

I figured it out.

Ran the following query on UCCX CLI:

run uccx sql db_cra select distinct * from contactcalldetail where originatorDN = 'XXXXXXXXXX'

Compared that to the Detailed Call CSQ Agent report off UCCX Historical Reports and filtered by the Originator DN (Calling Number).

I then ran a query on Quality Management to see how many of those calls were recorded.

607
Views
0
Helpful
2
Replies
CreatePlease to create content