These stored procedures are used to generate reports for that particular CSQ by either activity or distribution
In previous versions prior to 8.0 You could try running it from osql the command prompt and it should look similar to this, but copy the exact command after running the HRC report for the csq_activity and this query will be present in the HRC log files
I think that it would be useful to have a list of the stored procedure contents in the UCCX database schema to help with custom UCCX reporting. Can someone post the stored procudures on this forum? Once I find them I will be glad to post them.
Did you ever post these? I seem to be having issues displaying the historical reports stored procedures. I can't see any with Squirrel. IBM Data Manager allows me to see some, but i don't see any of the ones used for reports under the db_cra database.
Thanks for the very quick reply. Right after I posted this, I finally found where they are storing them. I was looking for the stored procedures under stored procedures. I'm silly that way sometimes. I now see that the majority of stored procedures (and all of the ones used by the historical reporting client) are stored under "user-defined functions". I'm good for now.
IntroductionCUCM Routing RulesDial String implementation PolicyCUCM Routing LogicSIP URI Call Routing Analysis+++ Case Study: 1 ++++++ Case Study: 2 +++Conclusion
Over the last few months, I have had the privilege of working on SI...
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...