MySQL Workbench or phpMyAdmin would be helpful tools for you.
The schema isn't terribly obscure.
For instance, the table named "ticket" holds ticket data.
Do you know how to write sql queries? (I need a base of understanding -- whether you need direction to accomplish the task yourself or you need someone to do it for you).
For instance:
number of tickets in each queue
select
q.name queue, count(
t.id) number from ticket t left join queue q on
q.id=t.queue_id left join ticket_state ts on
ts.id = t.ticket_state_id group by
q.name
number of tickets locked and unlocked in each queue:
select
q.name queue, sum(if(t.ticket_lock_id =1, 1, 0)) unlocked, sum(if(t.ticket_lock_id = 2, 1, 0)) locked from ticket t left join queue q on
q.id=t.queue_id left join ticket_state ts on
ts.id = t.ticket_state_id group by
q.name
(yeah, you're not going to find *that* one easily in a list).