topic UCCX Missed Calls in Unified Communications Infrastructure

UCCX Missed Calls

gustavo001 — Tue, 19 Mar 2019 13:06:29 GMT

Where can I found a field to describe the uccx missed calls in real time? I need the missed call, the calling number, the time, and the queue.

Thanks.

UCCX Missed Calls

Aaron Harrison — Thu, 10 Jan 2013 18:54:38 GMT

ContactCallDetail contains a record for each call. That would contain a 'contactDisposition' field to indicate handled or not etc.

Each queue that the call is sent to generates a record in ContactQueueDetail, so you'd check for rows matching the sessions/sequence/nodeid fields between those two tables.

Regards

Aaron

UCCX Missed Calls

gustavo001 — Tue, 12 Mar 2013 19:23:30 GMT

Hello Aaron,

I have looked for in the fields that you recommended, and I haven't found the calling number. How can I solve it.

Thanks,

UCCX Missed Calls

gustavo001 — Wed, 13 Mar 2013 17:11:01 GMT

hello Aaron,

excuse me, as you indicated, I found the field "originatorDN" in the table contactCallDetail.

I did an web page that show the lasts missed calls in the contact center.

SELECT originatorDN, startDateTime, contactDisposition, originatorType from contactcalldetail ccd INNER JOIN contactqueuedetail cqd ON (ccd.sessionID = cqd.sessionID AND ccd.sessionSeqNum = cqd.sessionSeqNum AND ccd.nodeID = cqd.nodeID) WHERE contactDisposition = 1 ORDER BY startDateTime DESC

It was successful.

Thanks,