Checking query for calls presented

[christina.singer1]

Hello,

I have reviewed at length the posted schema and query information for the UCCX database.  I was hoping someone could review my query below and let me know if I am missing anything.  I am trying to get a count of all calls presented for today so far (grouped by csq).  Thanks in advance for the help.

SELECT contactservicequeue.csqname,

contactqueuedetail.profileid, contactqueuedetail.targetid, COUNT(distinct contactcalldetail.sessionid)

AS [Calls Presented]

FROM UCCX.db_cra.informix.contactcalldetail CROSS JOIN

UCCX.db_cra.informix.contactqueuedetail CROSS JOIN

UCCX.db_cra.informix.contactservicequeue

WHERE (contactcalldetail.sessionseqnum = contactqueuedetail.sessionseqnum) AND (contactcalldetail.sessionid = contactqueuedetail.sessionid) AND

(contactcalldetail.profileid = contactqueuedetail.profileid) AND (contactcalldetail.nodeid = contactqueuedetail.nodeid) AND (contactqueuedetail.targetType = 0) AND

(contactqueuedetail.targetid = contactservicequeue.recordid) AND (contactcalldetail.startdatetime >= CONVERT(date, GETDATE()))

GROUP BY contactqueuedetail.targetid, contactqueuedetail.profileid, contactservicequeue.csqname

[pravin1]

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

[christina.singer1]

After 10 pm the phones go to voicemail.  Staff comes in to take calls from 7 am on.