In the attached sample you will see sample telephony data from Cisco UCCX Express from the agentconnectiondetail table.
This is the query I am running:
WHERE startdatetime >= TO_DATE('01-01-2015 05:00','%m-%d-%Y %H:%M') AND sessionseqnum = 0
My question is how can I make the information unique to the SessionID which is the unique identifier for the call but retain the employeenumber of the agent who answered the call?
For example I highlighted in the document on the sample tab the sessionID 43000086306. The data shows that for sessionID 43000086306 the call came in and rang at two agent positions before it was picked up by the third. You see this because the resourceID changes and 10 seconds of ringtime is logged for those positions but the phone was not picked up since the talktime is 0. How can I sum the ringtimes together and retain the resourceID number for the agent who picked up the call.