UCCX. CUIC. Operator hung up report

[DOM.RF NOC]

Colleagues, good day!

Where I could be see in the CUIC of Cisco UCCX 9.0 a report, which shows that the operator first hung up the phone without waiting for client to do so?

[Mark Grace · Accepted solution]

Unfortunately, there's no report in CCX that'll show you which side ended the call.  You'll need to look at Call Detail Records (CDRs) on CUCM.

https://supportforums.cisco.com/discussion/11290091/historical-reports-caller-hang-agent-hang

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/trouble/8_6_1/trbl861/tbdevice.html#wp1021136

[ahmed.zakaria]

If you used UCCE you can do it 

[ahmed.zakaria]

SELECT
call.startdatetime,
call.ani,
call.callguid,
callevent.transferlabel,
callevent.eventtypeid,
case
when callevent.causeid = 13 then 'Agent Released'
when callevent.causeid = 1 then 'Customer Released'
else 'Other' end as CauseIdLabel,
callevent.causeid
FROM call, callevent
WHERE call.callguid=callevent.callguid
AND (callevent.eventtypeid = 6 AND callevent.causeid IN (1, 13))
AND callevent.transferlabel < 5000
SELECT
call.startdatetime,
call.ani,
call.callguid,
callevent.transferlabel,
callevent.eventtypeid,
case
when callevent.causeid = 13 then 'Agent Released'
when callevent.causeid = 1 then 'Customer Released'
else 'Other' end as CauseIdLabel,
callevent.causeid
FROM call, callevent
WHERE call.callguid=callevent.callguid
AND (callevent.eventtypeid = 6 AND callevent.causeid IN (1, 13))
AND callevent.transferlabel < 5000
and callevent.transferlabel between (3501) and (3599) <<<<   Agent extensions range 
and call.ani not like 'NA%'
and call.ani not like 'NA%'