[rt-users] Reports

[Torsten Brumm]

Hi Steve,

the simpliest method is to define a custom search for a specific queue 
within RT with all the Fields you need. Save this search for later 
usage! If you do the search, the view you will get gives you at the 
bottom a link called (spreadsheet) which will open the result within 
Excel. This is only a very simple way but i think it will work for your 
needs.

Another way i can explain to you if you need more detailed reports. I 
have created during the last weeks a connectivity between the RT 
database and Business Objects to create much more better results - but 
this makes only sense if you have a Business Objects license.

Torsten

Hersker, Steve schrieb:

> 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
>
>------------------------------------------------------------------------
>
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
>Buy your copy of our new book, RT Essentials, today! 
>
>Download a free sample chapter from http://rtbook.bestpractical.com
>