Script to list reports and their help files

[RuthLammers]

Does anyone have a SQL scripts (or other report definition script format) that will pull a list of all reports in CUIC and the links to each of their help files (if it exists) they can share?

[bill.king1]

Hi, what are you looking to do? The PDF that Cisco puts out (not in the CUIC section but in the regular CCE section, for some reason I've never understood), has all of this information. I've included the link here.
https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/icm_enterprise/icm_enterprise_12_5_1/user/guide/ucce_b_reporting_user_guide-1251.html

[RuthLammers]

I've seen that document. 

What I'm trying to do is produce a list of all of our reports (almost 2,000) along with the link (URL? permalink? not sure what) for each one's help file.  That will allow us to determine what reports lack a help file and then track which need to be updated, deleted, etc.  Eventually, I'm sure I'd be able to create the script myself but I'm not familiar enough with the data schemas to do so on my own right now.

[david.macias]

I have to imagine these are stored in a directory inside the CUIC VM and without root access you're not going to be able to easily get to it. The other option, just as painful, would be around creating a script (maybe with Selenium) which goes through every report and extracts this data for you. If the CUIC DB schema was published there might be something there, but what you're trying to do might require a manual or programmatic solution custom built for this

david.

[bill.king1]

So you might want to check out this post, but what you could do is look at the table cuicreport in CUIC itself and the help file is referenced there.
https://community.cisco.com/t5/contact-center/user-list-for-cuic/td-p/3318509

[david.macias]

Genius!

david