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

rtcsqssummary table only showing last 25 created CSQ entries

We have a wallboard that is pulling CSQ stats from the rtcsqssummary table.

Its currently only showing the last 25 created CSQs on the wallboard. We have approximately 101 configured. Is there a limit to this table or is it configurable? We are running CCX version 9.0.2.10000-71.

 

Running this command and only 25 entries appear.

admin:run uccx sql db_cra select count (*) from rtcsqssummary
(COUNT(*))
----------
25

However its showing 101 configured and active.

admin:run uccx sql db_cra select distinct count(*) from contactservicequeue where active='t'
(COUNT(*))
----------
101

 

Thanks in advance.

1 REPLY
Super Bronze

HiThat table only updates on

Hi

That table only updates on the current 'active' node. If you have HA, maybe check the table on the other node, you may be looking at stale data on the secondary from last time it was active.

Otherwise... something odd is going on. There's no max, and no config, it may be reboot time ;-)

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
51
Views
0
Helpful
1
Replies
CreatePlease to create content