05-12-2014 09:36 AM - edited 03-15-2019 05:59 AM
Good morning support community,
Currently I have UCCX v9 and CUIC Premiun v9 and I was wondering if it is possible to link via HTML or other method report from uccx; for example, I have a custom report called "Handled vs Abandoned" and I would like to run it every hour and have the results in my solarwinds dashboard.
I tried to link the HTML source code CUIC gave me but it didn't work :(
I know I can create an ODBC connection to the server, but I don't know the database structure and is not going to help me.
In CUIC I can edit the report and customize the grids, but I cannot find the query :(
What other option do I have?
Thank you! :)
Rolando Valenzuela
05-15-2014 07:30 AM
Good morning support community,
What do you think should be the best option to run/pull reports from UCCX using a third party solution?
Thank you!
Rolando Valenzuela
05-20-2014 04:28 AM
Hi,
there are several options:
1. Copy/synchronize the internal historic database of UCCX with your own database server and use the latter as the data source of your reports. I have a very similar setup, with UCCE though, but from the technical point of view, this is irrelevant.
2. Use the internal UCCX DB as your database for running custom queries. The database schema is available, all you need to have is some SQL.
3. Embed a CUIC report into your web. Iframe should work (should = I did not test it myself).
G.
05-20-2014 12:41 PM
Rolando, Our 3rd party solution, either as an ASP or On-Prem option - most likely can accomplish your desired result. If interested to discuss details - please contact me. Ron Reif / SMSI / rreif@smsi.com
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