Generating Reports on RT queues

A wonderful question for ‘senior’ RT users:

This must have been a dream I had or maybe a rumor but could it be that
one of you can generate weekly/monthly reports from a queues’ transctions??

Someone kindly advise if possible. I am an RT newbie :wink:

-Wash

Odhiambo Washington wash@wananchi.com “The box said ‘Requires
Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,’
Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD.”
GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :slight_smile:
Quality Control, n.:
The process of testing one out of every 1,000 units coming off
a production line to make sure that at least one out of 100 works.

a message of 24 lines which said:

This must have been a dream I had or maybe a rumor but could it be that
one of you can generate weekly/monthly reports from a queues’ transctions??

My personal inclination (since I’m fluent in SQL) is to write a report
query directly in SQL such as:

SELECT Tickets.id,Tickets.subject,Tickets.created,Tickets.priority
FROM Tickets,Users WHERE Users.Name = ‘bortzmeyer’ AND
Users.id=Tickets.owner AND (status=‘open’ or status=‘new’)
ORDER BY priority DESC, Tickets.created ASC LIMIT 10;

RT’s schema is quite simple and easy to understand. Do not hesitate to
ask questions about specific points.