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

CUIC Hourly Interval Query Throughout Date Range (SQL Squirrel Stuff)


I’m trying to create a specific report in CUIC using the "Contact Service Queue Activity Report by Interval” canned report.  The objective is to query intervals (by hour), throughout the whole reporting time frame.  This can be done by interval and reported per day in the canned report, but I’m trying to get the values per interval without the day displayed.  For example, I’d like a report that shows total calls per hour (8-9 am, 9-10, 10-11am etc) throughout the reporting date range. The report would look like this:


Interval Start Time  Interval End Time     CSQ Name     Calls Presented    Handled
8:00:00 AM     9:00:00 AM     CSQ_     41     40
9:00:00 AM     10:00:00 AM     CSQ_     63     60
10:00:00 AM     11:00:00 AM     CSQ_     50     50


Instead of this:
Interval Start Time  Interval End Time     CSQ Name     Calls Presented    Handled
3/3/14 8:00     3/3/14 9:00     CSQ_     16     16
3/3/14 9:00     3/3/14 10:00     CSQ_     23     21
3/3/14 10:00     3/3/14 11:00     CSQ_     24     24
3/4/14 8:00     3/4/14 9:00     CSQ_     13     13
3/4/14 9:00     3/4/14 10:00     CSQ_     26     25
3/4/14 10:00     3/4/14 11:00     CSQ_     14     14
3/5/14 8:00     3/5/14 9:00     CSQ_     12     11
3/5/14 9:00     3/5/14 10:00     CSQ_     14     14
3/5/14 10:00     3/5/14 11:00     CSQ_     12     12

 

 

 

3 REPLIES
Super Bronze

HiSo you want the report to

Hi

So you want the report to add up all the calls between 9-10am, e.g. if you run it for a week it would add up the calls for each day between 9 and 10 am and show a single total for that hour?

Aaron

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

So the way I achieved this

So the way I achieved this was to export the report, alter the stored procedure, import into CUIC Premium, create procedure, save and then reimport into the CUIC on UCCX.

Super Bronze

That's the way :-)Smart work.

That's the way :-)

Smart work.

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
267
Views
0
Helpful
3
Replies