05-21-2015 09:37 AM - edited 03-14-2019 02:48 PM
Hi
We are having ucce 9.0 version, recently we found two days report of Skill_Group Interval for particular skill is handled call is less (80 calls)
but in general it will come around 200 calls.
I have checked the table in HDS server as follows
select sum(CallsHandled)as SS from t_Skill_Group_Interval
where DateTime between '19 May 2015 08:00' and '19 May 2015 20:00'
and
SkillTargetID=5131
Result: 75 calls
select* from t_Termination_Call_Detail
where DateTime between '20 May 2015 08:00' and '20 May 2015 20:00'
and TalkTime>0 and SkillGroupSkillTargetID='5131'
Result: 215 calls
And the same query we have checked in logger machine
select sum(CallsHandled)as SS from t_Skill_Group_Interval
where DateTime between '19 May 2015 08:00' and '19 May 2015 20:00'
and
SkillTargetID=5131
Result: 75 calls
select* from t_Termination_Call_Detail
where DateTime between '20 May 2015 08:00' and '20 May 2015 20:00'
and TalkTime>0 and SkillGroupSkillTargetID='5131'
Result: 215 calls
Could not able to understand what could be issue with Cisco UCCE application, it showing number of calls answered 215 in termination call detail
but it is missed out in skillgroup_interval table.
Before proceed to Cisco TAC, looking for some clue or work around or advise.
with Regards,
Manivannan
05-22-2015 02:44 AM
Hi,
please never use the t_ tables. Use the database views instead (Termination_Call_Detail, Skill_Group_Interval).
About the query: can you add something more specific (besides to TalkTime > 0) add AgentSkillTargetID IS NOT NULL and also CallDisposition = 13 (to the one on the TCD view).
G.
05-24-2015 06:47 AM
Hi,
I have tried the same (mentioned above), two more filters and running against Termination_Call_Detail and the result is almost same (10 calls lesser than old output)
Really wondering how Skill_Interval table is missed those calls
with Regards,
Manivannan
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: