09-22-2010 05:00 PM - edited 03-14-2019 06:33 AM
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
09-22-2010 08:52 PM
ICM puts a record into Route_Call_Detail for every Route_Request.
Do you notice duplicate records here?
Regards,
Dilip
02-17-2014 10:33 AM
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.
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: