cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

880
Views
0
Helpful
4
Replies
Beginner

Customize CSQ Activity by CSQ Report based on Application Name

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

1 ACCEPTED SOLUTION

Accepted Solutions
Contributor

Re: Customize CSQ Activity by CSQ Report based on Application Name

It is not recommended to modify stored procedures outside of the Reporting app.

View solution in original post

4 REPLIES 4
Contributor

Re: Customize CSQ Activity by CSQ Report based on Application Name

It is not recommended to modify stored procedures outside of the Reporting app.

View solution in original post

Beginner

Re: Customize CSQ Activity by CSQ Report based on Application Name

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

Beginner

Re: Customize CSQ Activity by CSQ Report based on Application Name

Hi,

The best practice is to recreate a new procedure based on that one.

Highlighted
Beginner

Re: Customize CSQ Activity by CSQ Report based on Application Name

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

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here