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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

CUIC report for the Call transferred.

Hello,

I am looking for CUIC report for the number of calls transfered by an agent. Below is the query that works fine in SQL, but i am unable to generate a CUIC report on this.

select AgentPeripheralNumber,count(*) from t_Termination_Call_Detail where

where DateTime between '02 Aug 2013 00:00' and '18 Sep 2013 23:59'

and

  ICRCallKey in (select ICRCallKeyParent from t_Termination_Call_Detail

  where DateTime between '02 Aug 2013 00:00' and '18 Sep 2013 23:59'

  and CED='2345')

group by AgentPeripheralNumber

Regards,

Sandeep

Everyone's tags (4)
2 REPLIES

CUIC report for the Call transferred.

Try querying "Termination_Call_Detail" instead of "t_Termination_Call_Detail".

Check out the CallDetailReport.xml report available here:

http://developer.cisco.com/web/ccr/documentation

That should be a good starting point for you.

-Jameson

-Jameson
New Member

Re:CUIC report for the Call transferred.

CUIC connects to the awdb, not hds.. the t_Termination_Call_Detail table is part of hds.. to call it from awdb, use the view Termination_Call_Detail instead

Sent from Cisco Technical Support Android App

519
Views
0
Helpful
2
Replies