Reporting Query Mismatch in ICM and CVP call count

Unanswered Question


We have a Comprehensive call model for SelfService IVRs. I see a descrepancy in the Call count  for the reporting purpose.


  |                 |

AWDB       ReportingDB

On the CVP reporting DB, I am using a query


"Select count(*) from call where DNIS=xxxxxx

and callstartdate between datetime1 and datetime2



Say it gives me a result  <Count1>

If I run a similar report against ICM AWDB route_call_detail


select count(*) from Route_Call_Detail

where DialedNumberString=xxxxxx

and RoutingBeganDate between Datetime1 and Datetime2


Say it gives me a result <Count2>

I find that Count2 always larger thant Count1. Not sure why this mismatch. any pointer on this is will be greatest help for me.


I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
cndilip123 Wed, 09/22/2010 - 20:52

ICM puts a record into Route_Call_Detail for every Route_Request.

Do you notice duplicate records here?



jimmy jain Mon, 02/17/2014 - 10:33

if you transfer the call , ICM Will write one more entry into RCD with same routercallkey and routercallkeyday.

hence you will find the second count always more, try using distinct keywork in RCD.


This Discussion