Cisco Support Community
Showing results for 
Search instead for 
Did you mean: 

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Calculating IVR duration and Queue duration.

Hi We have contact center with comprehensive call model with CVP.

call flow is as below

GW--->Cups-->CVP(Call server)---ICM ----(Run external Script for IVR) (VXML GW)----> Agent Queue ( Run external script for playing EWT and queue music) ---> Agent.

We want to calculate average duration spent on IVR (initial digit collection) and average Queue Time.

From the documentation of Termination_Call_Detail found that  DelayTime gives the duration before call being queued to Agent. But I see that DelayTimes  as 0 .

We are using the same script for IVR and Queuing.

ICM ver 7.5 with CVP 7.0.

Looking for help on /understanding how I can write a sql query to get this.

Everyone's tags (3)