Can someone please tell me what the numbers in the contact type field in the contactcalldetail table mean? Thank you!

Can anyone give me a hint about the SQL query used to calculate total logged in time (by agent) for a specific time period?

Could someone assist with a query to show how many calls an analyst handled each day (after defining a report period)? My company is trying to determine which analyst took the maximum number of calls (and when) over the course of a year. Thanks!

Can someone please direct me to the proper UCCX tables needed to answer the following question? I need to determine out how many callers had to wait longer than the average wait time for each queue.  Thanks!

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