Contact Center Reporting

« Back to Contact Center Reporting

Agent_Skill_Group_Half_Hour and Termination_Call_Detail tables in IPCC

Combination View Flat View Tree View
Threads [ Previous | Next ]
We have a question regarding on Agent_Skill_Group_Half_Hour and Termination_Call_Detail tables in IPCC Enterprise:
 
We are trying to obtain the number of calls handled by a skill group in half hour interval using the Termination_Call_Detail table.
However, the figures we obtained are different from those we got when querying the Agent_Skill+Group_Half_Hour table. Attached our SQL script for getting this.

Could you advise why there are discrepancies?
Is there any difference between data logging mechanisms of these two tables? Or our SQL script is incorrect?

Remarks: we are using Cisco IPCC Enterprise 7.0 version
Attachments:

I usually include in my where clause CallDispositionFlag='1' to ensure you are only counting handled calls as from my understanding your TCD query would also count short calls etc

we've tried to include the CallDispositionFlag='1' in our where clause, but this cannot solve the problem.
Does anybody has another solution to our problem?

Were you able to box out these two tables? I am going through the same process and find that for every one call in the Half_Hour table there are 3 records in the termination call detail table. I would be very interested in your findings if you were successful.
 
Brandon McDowall

Consistent data amongst various cisco tables seems to be a nightmare. This is not just with ICM data, i've seen the same across CVP, Call Manager, Trunk Groups.