Something like this might work. I'm in a UCCE environment with 2 AW/HDS servers for CUIC reporting. I can successfully run this query from either server. I used Microsoft SQL Server Management Studio to run the query.
use ucce_hds select DateTime, CallDisposition, ANI from Termination_Call_Detail where DateTime >= '2017-02-03 00:00' and DateTime <= '2017-02-03 23:00' and CallDisposition in (1,3) order by DateTime
Call disposition 1 is abandoned in network, 3 is abandon ring. There are other abandon codes but these ones should meet your request.
Your query was useful but i had to add to it Call disposition 2 as well. But this did not completely catch all abandoned calls. I made some test calls and and abandoned at different points as follows:
1. Closed the line once i was directed to the queue
2. Closed the line while listening to queue music (on hold)
3. Closed the line while agent phone is ringing
4. Closed the line while talking to agent
5. Completed the call normally and did not close the line until agent did.
I then queried the Termination_Call_Details for my number (ANI) to see the records created for these tests. I noticed that for some calls more records are created in TCD table than other calls. Below is the result call dispositions found in records associated with each test respectively:
1. 13,13 (two records each has call disposition 13)
Querying for call disposition 2, and 3 is good but it would only catch two types of the first three abandoned calls explained above. I'm still looking for a better query that would return all the first 3 abandoned calls as per the tests explained above.
For calls that abandon before being routed, the easiest table by far is the Route_Call_Detail table. Look at the RouterErrorCode. A value of 448 is an abandoned call. There will be no Label for this row in the RCD.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...
If you have 2 ISR routers, one acting as Failover, do we need to have both the same number of SRST licenses on the 2 routers?
No. You will only need the SRST licenses on the primary router. Because this feature...