05-09-2016 06:13 AM
Hi,
I have to create a CSQ activity report not filtered by CSQ name, but by Application name. We have UCCX version 10.6 with built-in CUIC. To achieve this goal, I built a standalone CUIC Premium to customize report definition. I use IBM Data Studio to access UCCX database and review the stored procedure used by the Contact Service Queue Activity by CSQ Report --- sp_csq_interval. I think I need to modify it by filtering the result with application name. The sp_csq_interval is calling another SP named getcsqintervaldata, which actually retrieves info from table Contactcalldetail and Contactqueuedetail. I need to acquire the application name here for further processing. So which SP should I really touch? It looks very complicated to me. What is the best approach for this task?
Any help is highly appreciated.
Quan
Solved! Go to Solution.
05-12-2016 04:49 PM
It is not recommended to modify stored procedures outside of the Reporting app.
05-12-2016 04:49 PM
It is not recommended to modify stored procedures outside of the Reporting app.
05-13-2016 05:08 AM
Thanks for the recommendation. Then what would be the best practice to achieve this task? Would that be too complicated to run a block of queries?
Much appreciated.
Quan
03-01-2018 04:18 AM
Hi,
The best practice is to recreate a new procedure based on that one.
08-31-2018 01:09 AM
Hi,
Does Cisco allow us to create new procedures on db_cra database or do we have password of "informix" or "uccxuser" db accounts which have dbadmin rights on db_cra database in Informix ? We have uccxhruser account and we can change password but this account has readonly permission on db_cra. So how can we create new procedures or do modifications on existing procedures on db_cra ?
Thanks alot your kind help in advance
Sedat
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: