cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

107
Views
0
Helpful
0
Replies
Beginner

Handled Calls Calculate different in TCD , SGI and ASGI

Hi,

 

Using Cisco 11.6

 calculate there are differences in some interval  on  Termination_Call_Detail , Skill_Group_Interval and Agent_Skill_Group_Interval.Mostly matching these tables for Handled calls.But some days are different.  Anybody knows why ? How can i match these tables? 

 

 

--Result 160
SELECT COUNT(*)
FROM dbo.Termination_Call_Detail
WHERE
CallTypeReportingDateTime BETWEEN '2019-12-12 13:30:00' AND '2019-12-12 13:59:00' AND
SkillGroupSkillTargetID = 5016 AND CallDispositionFlag = 1 AND PeripheralCallType = 2

 

--Result 156

SELECT SUM(CallsHandled)
FROM dbo.Skill_Group_Interval
WHERE
DateTime BETWEEN '2019-12-12 13:30:00' AND '2019-12-12 13:59:00' AND
SkillTargetID = 5016

 

--Result 156
SELECT SUM(CallsHandled)
FROM dbo.Agent_Skill_Group_Interval
WHERE
DateTime BETWEEN '2019-12-12 13:30:00' AND '2019-12-12 13:59:00' AND
SkillGroupSkillTargetID = 5016

Everyone's tags (1)
CreatePlease to create content
Content for Community-Ad
FusionCharts will render here