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

icm database (historical and logger) issue

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

 

2 Replies 2

Gergely Szabo
VIP Alumni
VIP Alumni

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.

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

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: