rtcsqssummary table only showing last 25 created CSQ entries

Unanswered Question
Sep 2nd, 2014
User Badges:

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


Running this command and only 25 entries appear.

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

However its showing 101 configured and active.

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


Thanks in advance.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Aaron Harrison Wed, 09/03/2014 - 06:53
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015


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 ;-)



This Discussion