Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

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

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

Everyone's tags (3)
1 ACCEPTED SOLUTION

Accepted Solutions

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

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

david

2 REPLIES

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

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

david

Community Member

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

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

719
Views
0
Helpful
2
Replies
CreatePlease to create content