Does anyone know if there is a table providing the total number of calls offered to the ICM per day ?
I looked at the Database Schema Guide and I couldn't such an information.
Eventually is there an SQL request that anyone knows which could provide this information ?
Thanks & Regards
Go to Solution.
Your best and easiest route is to look at a calltype report for your inbound numbers and just add them all up.
Thank you for your help. Here is the SQL query I made to query all the CallsOffered to the ICM
SELECT cast(floor(cast(DateTime as float)) as datetime) date_appel, sum(CallsOffered) CallsOffered
WHERE cast(floor(cast(DateTime as float)) as datetime) = '2012-06-29 00:00:00.000'
GROUP BY cast(floor(cast(DateTime as float)) as datetime)
ORDER BY 1