[rt-users] Reports

[Hersker, Steve]

Against my will and better judgment, I have to run weekly reports for
management to review (for regulatory compliance). A list of all open & new
tickets (with details and complete ticket history for each) and all tickets
closed the previous week (again with details and history) are two examples.

 

Before I can put RT in production, I have to find a way to generate these
reports. Has anyone done anything similar? If anyone just has the generic
SQL statement(s) that puts together the ticket, transactions and
attachments, I'd appreciate it.

 

Thanks

Steve

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051104/1fc86bd2/attachment.htm>