How to get Open ticket count for specic queue in OTRS by SQL query?
select count(*) from ticket
inner join queue on ticket.queue_id= queue.id
inner join ticket_state on ticket_state.id = ticket.ticket_state_id
where queue.name ='Postmaster' and ticket.ticket_state_id = 4
No comments:
Post a Comment