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.
It is not recommended to modify stored procedures outside of the Reporting app.
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?