cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
701
Views
0
Helpful
2
Replies

Reporting Query Mismatch in ICM and CVP call count

r.boloor.rao
Level 1
Level 1

Hi

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

ICM<-------->CVP<------->GW<--->caller

  |                 |

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.

Thanks

2 Replies 2

cndilip123
Level 1
Level 1

ICM puts a record into Route_Call_Detail for every Route_Request.

Do you notice duplicate records here?

Regards,

Dilip

jimmy jain
Level 4
Level 4

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.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: