[rt-users] Generating Reports on RT queues

[Stephane Bortzmeyer]

On Thu, Apr 04, 2002 at 07:07:53PM +0300,
 Odhiambo Washington <wash at wananchi.biz> wrote 
 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.