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
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