[rt-users] Where are Queue-level AdinCC's stored in the RT database?

[brian mccabe]

Hi there

I'm hoping someone can help me. I have a requirement as follows:

We have a queue that is managed during normal working hours by one set of people who watch it very closely and pick up tickets as and when required. Outside normal hours a separate team look after this queue and, because it is alongside other duties, tend not to be as diligent.

I am looking for a way to set this separate group of "out of hours" people up to be AdminCC's on the queue but only between certain times of day, on certain days of the week. I can't fathom out how to do this in a scrip, so thought the best way would be to run a job at set times of day that would insert a row into the underlying RT database making this group of users an AdminCC on that queue. At other times of day I would remove that row.

Surely its just a case of cronning a job that does something like:

insert into xyztab values (:queue_id, :group_id, 'Admincc') .. or something similar once I can fathom out the data model !

So - does anyone know where RT stores this internally? I have looked at all the tables and can't work it out.

Alternatively, if someone has a better way of achieving the same result then I'm open to all suggestions.

Thanks in advance

Brian