Preview Tool

Cisco Bug: CSCtb66314 - PercentUtilization field in SkillGroupInterval inaccurate

Last Modified

Dec 30, 2016

Products (1)

  • Cisco Unified Intelligence Center

Known Affected Releases


Description (partial)


There is a problem with the PercentUtilization column in the
SkillGroupInterval table in the Archiver database. For 30 minute intervals
PercentUtilization is correct when compared with the manual calculation. The problem comes
with PercentUtilization in the Daily, Weekly and Monthly intervals. The values of
PercentUtilization in these intervals are way higher then the manual calculation and
They appear to be a summation of values in shorter intervals instead of an average.


For test purposes the output of the following query will display values of PercentUtilization for 30 min, Daily, Weekly and Monthly
compared with the manual calculation. It's 

select DateTime
, IntervalID
ManualCalc = case when (LoggedOnTime - NotReadyTime) = 0 then 0 
else (TalkTime + WorkReadyTime + WorkNotReadyTime)
/ (LoggedOnTime - NotReadyTime)end

from dbo.Skill_Group_Interval
where DateTime between  '08/1/2009' and '08/12/2009'
and PercentUtilization >0 
order by IntervalID
Bug details contain sensitive information and therefore require a account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.