rtcsqssummary table only showing last 25 created CSQ entries

travisr · ‎09-02-2014

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.

Aaron Harrison · ‎09-03-2014

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!