How to add a stored procedure in Cisco UCCX 11.5 database

[The Juice Plus Company LLC]

Hi Everyone,

I needed to export a custom report from one CUIC cluster to another which i have done successfully but the report execution failed. I found out that the report was using a custom stored procedure to fetch the data for the report definition, now i need to connect with he first CUIC database and copy that stored procedure into the other CUIC

If someone could guide me how can i add a custom stored procedure into CUIC or UCCX database, I shall be extremely gratefull

both cluster are same version

Version 11.6(1)  Build 11.6.2.10000.38

Thank you

[david.macias]

It has been years since I've done this. I believe I used Squirrel SQL or mayb DB Viz, but I'm leaning to Squirrel more than likely. Once you connect to the DB you just need to Google how to add a stored procedure and you're good to go.

david