Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Cisco Community
- :
- About pulatsahin
Stats
Member since
05-31-2016
4
Posts
0
Helpful
0
Solutions
Created by
pulatsahin
in Contact Center
in Contact Center
01-15-2020
06:42 AM
01-15-2020
06:42 AM
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 ? How can i match these tables? --Result 160 SELECT COUNT(*) FROM dbo.Termination_Call_Detail WHERE CallTypeReportingDateTime BETWEEN '2019-12-12 13:30:00' AND '2019-12-12 13:59:00' AND SkillGroupSkillTargetID = 5016 AND CallDispositionFlag = 1 AND PeripheralCallType = 2 --Result 156 SELECT SUM(CallsHandled) FROM dbo.Skill_Group_Interval WHERE DateTime BETWEEN '2019-12-12 13:30:00' AND '2019-12-12 13:59:00' AND SkillTargetID = 5016 --Result 156 SELECT SUM(CallsHandled) FROM dbo.Agent_Skill_Group_Interval WHERE DateTime BETWEEN '2019-12-12 13:30:00' AND '2019-12-12 13:59:00' AND SkillGroupSkillTargetID = 5016
... View more
- Tags:
- reporting
Labels:
Created by
pulatsahin
in Contact Center
in Contact Center
01-15-2020
05:11 AM
01-15-2020
05:11 AM
-- this query you can use SELECT tcd.* from Termination_Call_Detail tcd inner join Route_Call_Detail rcd on tcd.RouterCallKey = rcd.RouterCallKey and tcd.RouterCallKeyDay = rcd.RouterCallKeyDay and tcd.CallTypeID = rcd.CallTypeID where rcd.RouterErrorCode = 448 and tcd.DateTime BETWEEN @from and @to AND rcd.DateTime BETWEEN @from and @to and rcd.CallTypeID = @calltype and rcd.RequeryResult != 5 and tcd.RouterCallKeySequenceNumber = 1
... View more
Created by
pulatsahin
in Contact Center
in Contact Center
01-15-2020
05:01 AM
01-15-2020
05:01 AM
Hi, The query in blow shows abandon in queue. DECLARE @from DATETIME = DATEADD(DAY,-1,GETDATE()) DECLARE @to DATETIME = GETDATE() DECLARE @calltype INT = 5591 SELECT tcd.* from Termination_Call_Detail tcd inner join Route_Call_Detail rcd on tcd.RouterCallKey = rcd.RouterCallKey and tcd.RouterCallKeyDay = rcd.RouterCallKeyDay and tcd.CallTypeID = rcd.CallTypeID where rcd.RouterErrorCode = 448 and tcd.DateTime BETWEEN @from and @to AND rcd.DateTime BETWEEN @from and @to and rcd.CallTypeID = @calltype and rcd.RequeryResult != 5 and tcd.RouterCallKeySequenceNumber = 1 ------ For Rona calls select tcd.* from Termination_Call_Detail tcd where tcd.DateTime BETWEEN @from and @to and tcd.CallDisposition = 19 and tcd.CallTypeID = @calltype
... View more
Created by
pulatsahin
in Contact Center
in Contact Center
06-24-2016
01:36 AM
06-24-2016
01:36 AM
Hi,
When I send to customer chat link I got error "There was an error posting the comment to Facebook Error: 400" . I didnt change any configuration for chat link. Please help !!!
Regards
Shahin Pulat
... View more
Labels:
Created by
pulatsahin
in Contact Center
01-15-2020
01-15-2020
Hi, Using Cisco 11.6 calculate there are differences in some interval on
Termination_Call_Detail , S...
Created by
pulatsahin
in Contact Center
01-15-2020
01-15-2020
-- this query you can useSELECTtcd.*fromTermination_Call_Detail tcdinner
joinRoute_Call_Detail rcd o...
Created by
pulatsahin
in Contact Center
01-15-2020
01-15-2020
Hi, The query in blow shows abandon in queue. DECLARE @from DATETIME =
DATEADD(DAY,-1,GETDATE())DECL...
Created by
pulatsahin
in Contact Center
06-24-2016
06-24-2016
Hi, When I send to customer chat link I got error "There was an error
posting the comment to Faceboo...
Public Statistics
| Date Registered | 05-31-2016 05:04 AM |
| Date Last Visited | 01-24-2020 12:48 PM |
| Total Messages Posted | 4 |
