NetMRG

RT Users
1

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?

Thanks

Alex Harrington - IT Support, Longhill High School

t: 01273 304086 | e: alex@longhill.org.uk

2

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