A place to ask questions, connect with others, and stay in the know
DECLARE @startdate DATETIME = '09/08/2022 00:00:00'
DECLARE @enddate DATETIME = '09/09/2022 00:00:00'
dateadd(second, ins.StartDTOffset, ins.ConnectedDateTimeUTC) [Connected],
att.InteractionIDKey [Outbound Attempt CallID],
DATEADD(second, att.StartDTOffset, att.StartDateTimeUTC) [Attempted],
DATEDIFF(SECOND, ins.ConnectedDateTimeUTC,att.StartDateTimeUTC) [Delay],
FROM [I3_IC].[dbo].[InteractionSummary] ins
JOIN [I3_IC].[dbo].[InteractionSummary] att
ON att.StartDateTimeUTC BETWEEN ins.ConnectedDateTimeUTC AND ins.TerminatedDateTimeUTC AND att.RemoteID = '+1' + ins.RemoteID
AND att.Direction = 2
WHERE ins.StartDateTimeUTC BETWEEN @startdate AND @enddate
AND ins.MediaType = 6
ORDER BY ins.ConnectedDateTimeUTC, att.StartDateTimeUTC
Every year, Genesys® orchestrates more than 70 billion remarkable customer experiences for organizations in more than 100 countries. Through the power of our cloud, digital and AI technologies, organizations can realize Experience as a Service℠, our vision for empathetic customer experiences at scale. With Genesys, organizations have the power to deliver proactive, predictive, and hyper personalized experiences to deepen their customer connection across every marketing, sales, and service moment on any channel, while also improving employee productivity and engagement. By transforming back-office technology to a modern revenue velocity engine Genesys enables true intimacy at scale to foster customer trust and loyalty.