Hi I am using following query extracted from UCCX stored procedure.
When I am running stored proceudre using CUIC output is correct and when I am standalone query using AGS server studio out data mismatch.
SELECT cqdr.targetid, csq.csqname, cqdr.profileid, Count(cqdr.sessionid)
, (Sum(cqdr.queuetime) / Count(cqdr.sessionid)), Max(cqdr.queuetime)
FROM Contactqueuedetail cqdr, Contactcalldetail ccdr, contactservicequeue csq
WHERE cqdr.sessionid = ccdr.sessionid AND
cqdr.sessionseqnum = ccdr.sessionseqnum AND
cqdr.profileid = ccdr.profileid AND
cqdr.nodeid = ccdr.nodeid AND
ccdr.startdatetime >= "2019-01-02 00:00:00.000" AND
ccdr.startdatetime <= "2019-01-02 23:59:59.999" AND
cqdr.targetid = csq.recordid AND
cqdr.targettype = 0
GROUP BY csq.csqname, cqdr.targetid, cqdr.profileid
order by csqname;
Contact center running morning 6 am tot 12 am.
Timezone is pacific standard time.
Regards,
Pravin