<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>RE: [rt-users] Reports</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>One thing that has been done very successfully for an RT implementation I have done in the past, is reports generated via MS Access.<BR>
<BR>
I know, I know... the dark one cometh....<BR>
<BR>
The scenario was essentially similar for me, but I was -very- disinterested in making reports happen. Especially for management who were very pro Microsoft. The answer we chose was that a Read-Only account was set up in the MySQL database, and then the managers in question could query the DB using their Microsoft Access clients.<BR>
<BR>
This worked very well, because it allowed them to fully view what was going on in the ticket management system, without them having any ability to modify anything. They could then use all of the gooey goodness (*pukes*) in MS Access to generate their Crayola Compliant management reports.<BR>
<BR>
The thing that was the biggest pain, was deciphering the schema of the database for RT. We found an old schema diagram, but even then we had to essentially decode it from scratch. (Here's a suggestion for you Jesse. It would be extremely useful at times to have a full Entity-Relation Model data diagram showing the RT schema and its relationships. As I said there is an older diagram floating around, but its a long way from an ER model).<BR>
<BR>
Regards,<BR>
BenR<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: rt-users-bounces@lists.bestpractical.com on behalf of Todd Chapman<BR>
Sent: Sat 11/5/2005 2:39 AM<BR>
To: Hersker, Steve<BR>
Cc: rt-users@lists.bestpractical.com<BR>
Subject: Re: [rt-users] Reports<BR>
<BR>
On Fri, Nov 04, 2005 at 09:37:21AM -0500, Hersker, Steve wrote:<BR>
> Against my will and better judgment, I have to run weekly reports for<BR>
> management to review (for regulatory compliance). A list of all open & new<BR>
> tickets (with details and complete ticket history for each) and all tickets<BR>
> closed the previous week (again with details and history) are two examples.<BR>
><BR>
> <BR>
><BR>
> Before I can put RT in production, I have to find a way to generate these<BR>
> reports. Has anyone done anything similar? If anyone just has the generic<BR>
> SQL statement(s) that puts together the ticket, transactions and<BR>
> attachments, I'd appreciate it.<BR>
><BR>
<BR>
That sounds unpleasant.<BR>
<BR>
You should never try to access RT data by going to the database<BR>
directly. The perl API is the preferred method.<BR>
<BR>
One option you might want to consider is writing a program that<BR>
can drive a web browser to run the queries and print each ticket.<BR>
It would look nicer than text reports, and you wouldn't have to<BR>
worry about the Perl API. Just a thought.<BR>
<BR>
-Todd<BR>
_______________________________________________<BR>
<A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR>
<BR>
Be sure to check out the RT Wiki at <A HREF="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>
<BR>
Buy your copy of our new book, RT Essentials, today!<BR>
<BR>
Download a free sample chapter from <A HREF="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>