Calls Within Service Level: Skill_Group_Interval Vs Termination_Call_Detail
I am facing issue with number of service level calls using query on TCD and another on Skill_Group_Interval , the output number from TCD always greater than SGI number , query used for both within same interval , on the same skill group.
Query used to select number of calls within service level threshold :
select DAY(DateTime) as Day , SkillGroupSkillTargetID, count(*)as ServiceLevelCalls from Termination_Call_Detail
where SkillGroupSkillTargetID in (5008,5010,5287,5011,5015,5288,5012,5346)
and CallDispositionFlag = 1
and PeripheralCallType = 2
and NetQTime <= 20
and DateTime between '2016-10-10 00:00:00' and '2016-10-13 00:00:00'
Group by SkillGroupSkillTargetID , DAY(DateTime)
order by Day(DateTime)
Here i use NetQTime the number of seconds call wait on queue (20 Service level threshold value)
and the other one i got the results from CUIC report (peripheral skill group interval all fields) on the same skill groups at the same time interval
Always the number of query output greater than report output
also i tried to add to NetQTime + RingTime + DelayTime + NetworkTime
the difference get smaller but still there is difference in output
I'm not the expert on this data, but I will point out a few things.
I believe a TCD record is only written for calls that complete, so the count may not match the SGI count.
The calculation for Service Level is quite complex, there are a number of places the Service Level can be over-ridden. If you dump the SQL for a template which reports Service Level, you can see what I mean.
In addition to Jack's response, the service level for a Skill Group starts when a call is queued to a skill group, and not when the call enters the system. If there is pre-call treatment (or other scripting) prior to when a call is queued to a skillgroup, this will need to be accounted for.
I want to find out how many agents are configured for an attribute. I have followed all the steps which are provided by the Cisco UCCE 11.6 API guide but I could not get the count. Is it possible to get a count of agents or not?
Collaboration Management Knowledge Base
For one-on-one help with these products, you can open a ticket at https://developer.cisco.com/site/support/. For other products, please contact Cisco TAC at https://www.cisco.com/c/en/us/support/index.html
Lately I have received a few requests from people asking if it was possible to Archive a Webex MessageSpace as in "download all messages".Interesting.
You can download all messages using the messages API but that leaves yo...
On May 10th 2021 a new API component was added: SPACE Tabs!
We call them ROOM tabs to be consistent with the room (space) API. Room Tabs represent an always available tab that is added as a tab in the space. It is co...
In a previous article I talked about the Cards & Buttons functionality of Webex Message. It's great to send nicely formatted or interactive messages.
What if you want to learn about Cards? There is a bot that teaches you all about Cards using...