01-19-2020 02:00 PM
hello, we have a cisco UCCX server installed and working properly.
Then out manager ask we must get a report about only work hours and another report about non-working hours but these
report is not beeing in uccx reports.
And I want to know where UXXC server stores all report and how I get from all report from database and then I will create some script to get information which is needed? thanks
Solved! Go to Solution.
01-20-2020 05:52 AM
I think that it will be hard to guess as there is no "show password" feature, but you could try "cisco", it can work. I think that it will be better to set the new password for this user but remember that you will need to change it also on CUIC side in Datasource configuration.
01-19-2020 08:13 PM
Hello,
All the reports in CUIC are defined as a stored procedure and are defined in the UCCX db_cra database. Before you begin you here are some useful tips that you can use:
01-20-2020 01:28 AM
Thank you for replying.
Can you tell me how to find our UCCX database server name parameters, and connect database to get reports?
01-20-2020 01:43 AM
Here is a set of parameters provided for Razor:
Here is more details:
And last tip:
If you build a custom stored procedure and you have HA deployment you will need to upload it on both nodes. Custom stored procedures don't auto-replicate.
01-20-2020 04:11 AM - edited 01-20-2020 04:12 AM
01-20-2020 05:52 AM
I think that it will be hard to guess as there is no "show password" feature, but you could try "cisco", it can work. I think that it will be better to set the new password for this user but remember that you will need to change it also on CUIC side in Datasource configuration.
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