I'm interested to design a query to know who ended the call with the customer service agent. Was it the agent or the caller (I mean who closed the line to release the call). I'm looking for a query that would return one record for every call contain...

Can someone help me design a sql query to get the abandoned calls while waiting on queue + the abandoned calls while ringing on Agent. I'm trying to use this query on UCCE 11. Also it would be very beneficial to to include the caller ANI in the quer...