Mysql query to find out what tickets were assigned to a queue

RT Developers
1

Hi,

I do not seem to be able to find how to see when a ticket is assigned to a queue or the number.

The transactions table only has entries for groups.

Am I misunderstanding something here or is this data available?

Thanks

2

Looking in the transactions table I see a record like this:

 140 | RT::Ticket    |        1 |         0 | Set     | Queue        | 1        | 3                                                                                               |               |              |              |            |      14 | 2022-01-13

Which shows the ticket going from queue 1 to queue 3

3

This was perfect, thank you.