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

UCCX 8.5 - Custom reports (not using Crystal)

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?

  • Contact Center
Everyone's tags (3)
1 REPLY

UCCX 8.5 - Custom reports (not using Crystal)

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.

HTH,

Tanner Ezell
www.ctilogic.com

Tanner Ezell www.ctilogic.com
168
Views
0
Helpful
1
Replies
This widget could not be displayed.