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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

IVR Traffic Analysis Report

I do a sql enquiry for the Cisco historical traffic analysis as below:

admin:run uccx sql db_cra CALL db_cra:informix.sp_ivr_traffic_analysis ('2012-01-10 23:00:00', '2012-01-18 4:00:00', 28800, 0 )

DATEVALUE       TOTAL_INCOMING_CALLS    AVG_CALLS       PEAK_CALLS   START_PEAK_HOUR END_PEAK_HOUR   AVG_CALL_LENGTH MIN_CALL_LENGTH      MAX_CALL_LENGTH FINAL_AVG_CALLS FINAL_AVG_CALL_LEN   LATESTSYNCHEDTIME

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

null    -8888   -8888.0 -8888   null    null    -8888   -888-8888    null    null    2011-12-28 16:00:02.0

2012-01-10 23:00:00.0   3564    209.64706       444     2012-01-11 07:00:00.0        2012-01-11 08:00:00.0   69      0   777      186.0   49      2011-12-28 16:00:02.0

2012-01-11 16:00:00.0   3473    144.70833       450     2012-01-12 02:00:00.0        2012-01-12 03:00:00.0   70      0   728      186.0   49      2011-12-28 16:00:02.0

2012-01-12 16:00:00.0   3348    139.5   402     2012-01-13 01:00:00.0        2012-01-13 02:00:00.0   66      0       627 186.0    49      2011-12-28 16:00:02.0

I noticed the datevalue is on 2012-01-10 but the peak hour it captured is 2012-01-1.

Anyone have any idea?

Everyone's tags (4)
3 REPLIES
Super Bronze

IVR Traffic Analysis Report

Hi

You have run the SQL SP with the start date set to 2012-01-10.... So it will start from that time?

The HRC software does one-hour offset this I think depending on the setting of the UTC setting in the drop down menus.

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

IVR Traffic Analysis Report

Hi,

The date is 2012-01-11 and not 2012-01-1 marked in red in your question.

New Member

IVR Traffic Analysis Report

Hi all,

Can this report/stored procedure be modified to differentiate results from one CSQ to another?

Thanks!

-JT-

773
Views
0
Helpful
3
Replies