topic Re: sp_ccdr parameters for custom report in Unified Communications Infrastructure

sp_ccdr parameters for custom report

brmoore — Tue, 19 Mar 2019 19:59:53 GMT

I'm building a custom report and I'd like to present current data from sp_ccdr, either by calling it directly or creating a query that pulls the same data. Is there someplace (I'm new to the UCCX system) that tells me what parameters can be passed in, and/or what the sp_ccdr is comprised of so I can 'duplicate' it?

I've been digging around, and it may just be my being new, but I can't seem to find something like "sp_ccdr takes x, y and z" and "sp_ccdr" runs q query or q and r query.

Can someone give me a pointer, please?

Re: sp_ccdr parameters for custom report

Jonathan Schulenberg — Thu, 14 Dec 2017 21:07:39 GMT

Use SQuirrel SQL or AGS ServerStudio to connect over ODBC and look at the stored procedure directly. The hruser even has write permissions to create stored procedures if you want to copy and tweak it.

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_11_6/reference/guide/uccx_b_unified-ccx-report-developer-guide.html

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_11_6/reference/guide/UCCX_BK_CF9FAD2A_00_cisco-unified-ccx-database-schema.html