About pulatsahin

pulatsahin · 01-15-2020

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 ? ...

pulatsahin · 01-15-2020

-- this query you can useSELECTtcd.*fromTermination_Call_Detail tcdinner joinRoute_Call_Detail rcd on tcd.RouterCallKey = rcd.RouterCallKey and tcd.RouterCallKeyDay = rcd.RouterCallKeyDay and tcd.CallTypeID = rcd.CallTypeIDwherercd.RouterErrorCode = ...

pulatsahin · 01-15-2020

Hi, The query in blow shows abandon in queue. DECLARE @from DATETIME = DATEADD(DAY,-1,GETDATE())DECLARE @to DATETIME = GETDATE()DECLARE @calltype INT = 5591SELECTtcd.*fromTermination_Call_Detail tcdinner joinRoute_Call_Detail rcd on tcd.RouterCallKey...

Member Since	‎05-31-2016 05:04 AM
Date Last Visited	‎01-30-2020 03:01 PM
Posts	4

User Statistics

User Activity

Handled Calls Calculate different in TCD , SGI and ASGI

Re: Abandoned Call Calculation From Termination Call Detail

Re: Abandoned Call Calculation From Termination Call Detail