Counting the total number of calls offered to the ICM per day

[NICNGUYEN]

Hi Team,

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

Nick

[david.macias · Accepted solution]

Your best and easiest route is to look at a calltype report for your inbound numbers and just add them all up.

david

[NICNGUYEN]

Hi David,

Thank you for your help. Here is the SQL query I made to query all the CallsOffered to the ICM

USE xxx_hds

GO

SELECT cast(floor(cast(DateTime as  float)) as datetime) date_appel,   sum(CallsOffered) CallsOffered

FROM t_Call_Type_Interval

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

Regards

Nick