07-09-2010 01:30 PM - edited 03-14-2019 06:03 AM
Hi,
I'm a little new to UCCX. We would like to know the extent of the API for pulling inforamation form historical reports statistics to a seperate server. Is there any API for interacting directly with the DB or is it done throught XML?
Are the any documents outlining this as well?
Thanks for your time!
-Sam
07-11-2010 07:16 AM
There is no API in this product yet. If you are running version 7.0 or earlier, a DTS job is a possibility to capture the databse and copy it off-box with a scheduled job in Windows. This is documented in the historical reporting administrator guide. In version 8.0 and later, your only option will be to perform an Informix ODBC connection and copy the tables that you wish to use periodically. The only time that remote ODBC queries are officially supported are with a wallboard product. Otherwise, remote database access is only officially supported when using Crystal to design reports that will be used within the Historical Reporting Client.
11-04-2016 12:33 PM
Johathan,
Any update in your answer for later versions?
11-07-2016 07:02 AM
Starting UCCX 9, there is lot of things you can do using Rest APIs within CCX. Refer below:
https://developer.cisco.com/fileMedia/download/6850746d-1139-4578-8290-0fd3979659ec
Regards
Deepak
10-21-2021 04:20 AM
Hi Jonathan,
Is it possible now in UCCX 12.5??
10-26-2021 06:52 AM
Still no API for this.
I have made a c# scripts that copy data directly from the informix db_cra db to an external microsoft SQL DB, so we can use Power BI for reporting.
This is done every night (for the day before).
Im take data from
agentconnectiondetail
agentstatedetail
contactcalldetail
contactqueuedetail
contactroutingdetail
ressource
contactservicequeues
This covers pretty much all the data for make you own report.
09-11-2023 02:40 AM
Dear Thomes,
can you give me some of scripts you created .
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