Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

RtCSQsSummary table doesn't exist

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

Everyone's tags (3)
3 REPLIES
Super Bronze

RtCSQsSummary table doesn't exist

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

Aaron Harrison

Principal Engineer at Logicalis UK

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

RtCSQsSummary table doesn't exist

Thanks Aaron. I am able to see the tables now.

Super Bronze

RtCSQsSummary table doesn't exist

Good stuff - please remember to mark questions as 'answered' to highlight useful content.

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
681
Views
5
Helpful
3
Replies