I have a customer requesting a report of the calls per hour per agent...Say I go into the reporting system that I have setup and the person is able to select a date range and queue name, the output should show a series of tables (one for each day) that includes agent name, with the number of calls taken per hour....
can anyone point me in the right direction of a sql statement that would querry the database to do so?
Custom reporting on the UCCX platform can be a real chore, luckily if what you're doing is only a modification of an existing report you can create the new report with minimal hassle.
UCCX primarily uses stored procedures to generating report data, the procedure name and variables it consumes are provided in the report defintions provided with the HRC client (check the installed directory). This is an XML file you can parse.
From there, you may customize to your hearts content and display to whatever interface deemed appropriate.
You may wish to consult both the UCCX Database Schema and Historical Reports developer guide for your partitcular version of UCCX.
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...
[toc:faq]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 discusse...