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