[rt-users] NetMRG

[Ruslan U. Zakirov]

Alexander Harrington wrote:
> Hi
> 
> I need to produce a graph of New and Open ticket numbers in an RT queue with NetMRG.
> 
> NetMRG has an SQL query method to return a number, so my question is, does anyone have an SQL query to return the number of new tickets and the number of open tickets in a given RT queue?
SELECT q.Name, t.Status, count(1) FROM Tickets t, Queues q WHERE q.id = 
t.Queue GROUP BY q.Name, t.Status;

http://wiki.bestpractical.com/index.cgi?DBSchema

> 
> Thanks
>