06-14-2023 10:12 AM
I have a ServiceNow instance, that i would like to gather report data from Cisco Unified Intelligence Center. Currently i am manually exporting reports, manipulating them, and then ingesting them into servicenow. Id love to have some assistance in setting up an API for ServiceNow to make a REST call to cisco to gather the data required automatically. Has anyone done this? any assistance or documentation on how to configure would be highly appreciated.
06-14-2023 10:55 AM
I think i Would be Easy to take the data directly from the uccx database and import Them in ServiceNow
You Can also runnthe sp from the database the reports is using
There is no api for cuic and reports
06-14-2023 11:01 AM
I guess i need to access UCCX's api to get the reporting data? trying to figure this out, im a ServiceNow Admin, not cisco, so my apologies there.
06-14-2023 11:27 AM
You Can’t get the reporting from an api.
You need to look into the cisco database directly, og you Can set cuic to export data to a flat file ( csv) and grab the data from there
06-14-2023 11:46 AM
06-14-2023 12:06 PM
As i Can se on ServiceNow import, you should be anle to import from jdbc ( database )
Or you have to ude the csv via ftp ( sorry )
06-14-2023 12:23 PM
06-14-2023 12:32 PM
It's Informix... assuming you have the informix JDBC drivers set up:
jdbc:informix-sqli://uccxhostname:1504/db_cra:INFORMIXSERVER=uccxhostname_uccx
i Can send you some more tomorrow
06-14-2023 12:39 PM
06-15-2023 06:28 AM
You will need to install the informix ODBC driver there.
You can download it from here (My personal onederive) : https://1drv.ms/u/s!AgCUg-AgroXy0RrCin_Iwtmam664?e=X57Z1b
For configuring it you can read more here : Create an ODBC Connection to connect to Cisco UCCX server | Amr Gaber - Technical Library (wordpress.com)
After that you should be able to connect to the DB.
For the data you should look in the ContactCallDetail table. This is where all calls are...
06-15-2023 06:58 AM
06-15-2023 06:28 AM
Which data are you looking for ?
07-10-2023 04:55 AM
I am looking to pull a report similar to the out of the box:
Contact Service Queue Activity Report by Interval
Contact Service Queue Activity Report
These reports need to be modified slightly, but in general these should give an idea of what were looking for.
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