call to Call Information on IPCC Enterprise

Unanswered Question
Jan 7th, 2008
User Badges:

Hello All,

Is there a way to get a call to call information of each caller that hits the ICM that can be reported on. Currently, Webview has this information on a 30 mins average, cumulative information.

Our users want information such as

1. How long each caller stayed in the queue.

2. How long it took to work on a specific call.


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
msaskin Tue, 01/08/2008 - 08:22
User Badges:

I've never been big on custom webview reports, but the information you're looking for can certainly be had from within the HDS database.

Take a look at the t_Termination_Call_Detail table - it contains a row for every distinct route that a call takes. For example, if you have inbound calls receive IVR treatment then pass to an agent, you should have 3 rows per call, excluding transfers, etc.

For each route, you can see various data points, including the amount of time the call spent in various states (talking, ringing, hold, etc.)

For more information, you may want to look at the IPCC Enterprise Database Schema document, which describes the various tables in the HDS and AWDB in great detail.

asomanya Tue, 01/08/2008 - 11:22
User Badges:

Thanks msaskin, that was the information I was looking for Regards

Riccardo Bua Wed, 01/09/2008 - 08:33
User Badges:
  • Cisco Employee,

HI there,

to better qualify this activities, there is the Call Type definition, instead of polling everytime the TCD which could be quite intensive, you could define specific call flow as call types and then report based on their use.




This Discussion