[cisco-voip] Additional historical reports available on CCO

[Anthony Holloway]

I'm only just seeing this now for the first time, and so, I just tried to
import one report, and so far it worked for me.  I'll try the rest in a
moment, but for now...

Here's what I have, and what I did.

My UCCX is 10.6.1.11001-31

   1. Downloaded CCX_NEWREPORTS.zip from http://www.cisco.com/
   2. Extracted CCX_NEWREPORTS.zip to folder CCX_NEWREPORTS
   3. Opened the Import Guide MS Word document from within the ZIP archive
   and began reading the instructions to import the first report
   4. Downloaded AGS Server Studio from
   http://www.serverstudio.com/downloads/
   5. Followed AGS instructions to install and register the product
   6. Logged into UCCX App Admin and set the password for the Historical
   Reporting User (uccxhruser) under Tools > Password Management
   7. Entered the connections details for UCCX into AGS Server Studio per this
   guide
   <http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_02/programming/guide/UCCX_BK_CFD16E30_00_cisco-unified-contact-center-express/UCCX_BK_CFD16E30_00_cisco-unified-contact-center-express_chapter_0100.html#UCCX_TK_B927C100_00>
   8. Now I'm connected to UCCX DB, and I can see the DB details in AGS
   Server Studio
   9. I expand Databases on the left, then right click the db_cra database
   and select New > SQL Editor
   10. I open the .sql commands in Notepad++ for the first report in the
   file from the ZIP archived CCX_NEWREPORTS\Report Stored
   Procedures\sp_reasoncode_agent_grouping.sql
   11. Copy those commands from Notepad++ and paste them into the SQL
   Editor pane in AGS Server Studio
   12. Click the Execute button (Green Arrow in Tools Bar) Or you can press
   CTRL+E
   13. Scroll through output in bottom pane and check for errors, I saw none
   14. Logged into CUIC as application administrator
   15. Created a new folder under the Reports folder and named it
   "Non-Stock"
   16. Clicked Import Reports button at top of Reports page
   17. Clicked Browse to open the report definition for the report I'm
   importing CCX_NEWREPORTS\Report Templates\New Reports\Reason Code Report by
   Agent Grouping.zip
   18. Selected the "Non-Stock" folder as the Save To folder and clicked
   Import
   19. Got an error about needing to pick data sources, so I picked UCCX as
   the data source for both the definition and the value lists, then clicked
   Import again
   20. I now see a new folder under the folder "Non-Stock" for the report I
   just imported
   21. Within that new folder, which is the name of the report "Reason Code
   Report by Agent Grouping" the report itself is in there, with the same name
   "Reason Code Report by Agent Grouping" (Nesting is good right?)
   22. I click the new report, set some filter, run it and bam, I have a
   new report

The hardest part was obtaining, installing, registering, and configuring
AGS Server Studio to connect to the UCCX database.  With that done, I can
start on step 9 for the remainder of the reports.

On Fri, Apr 8, 2016 at 8:30 AM, Ed Leatherman <ealeatherman at gmail.com>
wrote:

> Good morning,
>
> It was pointed out to me that there were a handful of new historical
> reports for UCCX/CUIC 10.6/11 up for download on CCO in the downloads
> section. Others might be interested also.
>
> Anyone try these out? I added in the Reason Code Report by agent (added SP
> and template OK) but I just get a Dataset status is Failed (Database error)
> and then a big pile of java error that makes no sense to me. I'm importing
> the report as the appadmin user account so that I can import it into the
> stock reports folder for my internal customers and change permissions on it
> so they can all access it.
> Thanks!
>
> --
> Ed Leatherman
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160408/afcf9249/attachment.html>