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
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...