04-22-2015 04:31 PM
We recently upgraded our UC environment to 10.5 and bought the CUIC premium license. but since we are new to the product we are having difficulties creating a agent detail report and Cisco tac does not support customized reporting.
So, are there any documents out there that might shed some light as to how to create a template under the report definitions, assign a report to the template and run a report using CUIC 10.5?
I found a agentdetailreport.xml version 9.x from the link below but i am not sure if it would work on 10.5. Any help would be greatly appreciated.
Steve
04-23-2015 05:51 AM
Steve,
In general, reports from earlier versions of CUIC will most likely work on newer versions of CUIC. The database schema has been quite consistent between versions. If your import doesn't work, try taking the SQL query out of the agentdetailreport.xml file and create your own Report Definition from that.
For reference materials, try the following:
End-User Guides: Cisco Unified Intelligence Center - End-User Guides - Cisco
Database Schema: Cisco Unified Contact Center Enterprise - Technical References - Cisco
I open up the Database Schema more than any other Cisco guide.
If you don't know SQL, you will need to learn it in order to start writing your own Report Definitions. Start by looking at the definitions for the stock reports. There are some good SQL tutorials on w3schools.com as well, and if you look around this very forum, you should find a few attempts by some of us at some interesting reports.
-Jameson
04-24-2015 09:46 AM
thank you for the information. I really appreciate it.
Would you know if UCCX CUIC 10.5 xml files will work in PCCE CUIC 10.5?
Steve
04-24-2015 10:06 AM
Steve,
No, UCCX reports will not work for UCCE or PCCE. The two systems are quite different in design, and have completely different database structures.
-Jameson
04-24-2015 10:09 AM
UCCX and PCCE are different animals. UCCX has an Informix back end and all of the stock reports are done with stored procedures. PCCE has a SQL Server backend and most of the reports are SQL based. You can use the UCCE templates for PCCE as those are essentially the same. PCCE also supports Livedata reports which are quite interesting.
Regards,
Jack Parker
04-24-2015 10:51 AM
Thank you gentlemen for the information.
One last question. Would you be able to point me to the site where I can download the UCCE templates? Thanks again for your help.
Steve
04-24-2015 10:59 AM
LOL. thank you.
Steve
04-24-2015 10:55 AM
See reply #2, there is a link there carefully disguised as "Cisco Systems".
Regards,
Jack Parker
04-24-2015 12:02 PM
... So good he had to say it 4 times.
04-23-2015 06:35 AM
Steve,
Good answer from Jameson.
You should also check the CCO downloads for Stock templates. Those can be found here: Cisco Systems
Match your CUIC version on the left, there is a readme file for each folder which describes the reports and what versions they work for.
Regards,
Jack Parker
05-05-2015 01:51 AM
Is there any Stock templates for UCCX? I have applied the premium license for UCCX but i can only found some "stored procedure" in the report definition. i need some sample sample report (SQL/ XML) for reference to help report customization. Thanks.
Regards,
Dennis Wong
05-05-2015 01:58 AM
Hi Dennis,
Did you apply CUIC premium license on UCCX box or did you apply UCCX Premium license?
You are not allowed to apply CUIC premium on UCCX box. If you need to do custom reporting & that is the reason you need CUIC Premium then you need to have a CUIC standalone installed & apply CUIC premium on that standalone box. Please clarify.
Thanks,
Vikram G
CUIC Product Manager
05-05-2015 02:06 AM
Hi Vikram ,
I have a standalone box for CUIC Premium and i have another box for UCCX.
In UCCE/ PCCE, there is Stock templates and i can take it as reference easily. Is there any similar template for UCCX? Otherwise i need to build customized report from nothing. (Or only with the database schema dcoument....... )
Thanks!
Regards,
Dennis Wong
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide