07-31-2012 01:57 PM - edited 03-14-2019 10:17 AM
We recently updgraded to
UCCX 8.5.1.11003-32
We have issue with dashboard, where they are not able to get the data by running following queries.
admin:run sql SELECT loggedinagents FROM RtCSQsSummary
The specified table (rtcsqssummary) is not in the database.
admin:run sql SELECT loggedinagents FROM RtICDStatistics
The specified table (rticdstatistics) is not in the database.
Please help me on this issue. Thanks in advance
07-31-2012 02:08 PM
Hi
'run sql' is for CUCM to run against the main CCM DB. On UCCX it seems to do not much though I'm sure there are some tables in that as well.
For the db_cra, use this:
run uccx sql db_cra select * from rtcsqssummary
For your dashboard, also ensure you have set up snapshot writing in Tools/Real Time Snapshot in AppAdmin or those tables will be empty...
Regards
Principal Engineer at Logicalis UK
Please rate helpful posts...
07-31-2012 02:27 PM
Thanks Aaron. I am able to see the tables now.
07-31-2012 11:52 PM
Good stuff - please remember to mark questions as 'answered' to highlight useful content.
Aaron
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