<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>RE: [rt-users] Reporting tools</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial">Hi,</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial"> I don</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial">t think there are really any reporting packages out there for RT that are really going to cover all the bases. </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial">We ended up just writing up some custom scripts (combination of RT API calls and straight SQL)</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT COLOR="#000080" SIZE=2 FACE="Arial">to export various stats as csv, which is imported into a</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT COLOR="#000080" SIZE=2 FACE="Arial">commercial</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial"></FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT COLOR="#000080" SIZE=2 FACE="Arial">stats system (which handles KPI</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial">s and all that rubbish</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT FACE="Wingdings" SIZE=2>J</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial"> ).</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial">Not much help.. but</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT COLOR="#000080" SIZE=2 FACE="Arial">that’s</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial"> how we do it</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> <FONT FACE="Wingdings" SIZE=2>J</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT COLOR="#000080" SIZE=2 FACE="Arial">Regards,<BR>
Matt.</FONT></SPAN></P>
<BR>
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma">_____________________________________________<BR>
</FONT></SPAN><SPAN LANG="en-au"><B></B></SPAN><SPAN LANG="en-au"><B></B></SPAN><B><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma">From:</FONT></SPAN></B><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"> rt-users-bounces@lists.bestpractical.com [<A HREF="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</A>]</FONT></SPAN><SPAN LANG="en-au"><B></B></SPAN><SPAN LANG="en-au"><B></B></SPAN><B><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Tahoma">On Behalf Of</FONT></SPAN></B><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Tahoma">Andrew Xenides<BR>
</FONT></SPAN><SPAN LANG="en-au"><B></B></SPAN><SPAN LANG="en-au"><B></B></SPAN><B><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma">Sent:</FONT></SPAN></B><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"> Thursday, April 07, 2005 1:49 PM<BR>
</FONT></SPAN><SPAN LANG="en-au"><B></B></SPAN><SPAN LANG="en-au"><B></B></SPAN><B><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma">To:</FONT></SPAN></B><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"> rt-users@lists.bestpractical.com<BR>
</FONT></SPAN><SPAN LANG="en-au"><B></B></SPAN><SPAN LANG="en-au"><B></B></SPAN><B><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma">Subject:</FONT></SPAN></B><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"> [rt-users] Reporting tools</FONT></SPAN><SPAN LANG="en-au"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">Hi people</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">I was wondering if there are any decent reporting tools for RT. Ive tried statistics3.tgz from the ftp, but it doest quite do what I need. I need to be able to do reports by owner as well as queues. And perhaps groups too.</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial">thanks</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><B><FONT COLOR="#000080" SIZE=2 FACE="Arial">Andrew Xenides<BR>
Web Developer<BR>
EscapeNet<BR>
465 South Road<BR>
Keswick SA 5035<BR>
T: (08) 8292 5200<BR>
F: (08) 8292 5299<BR>
E:</FONT></B></SPAN><SPAN LANG="en-au"> </SPAN><A HREF="mailto:andrew@staff.esc.net.au"><SPAN LANG="en-au"><B></B></SPAN><SPAN LANG="en-au"><B><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">andrew@staff.esc.net.au</FONT></U></B></SPAN><SPAN LANG="en-au"></SPAN></A><SPAN LANG="en-au"><B></B></SPAN><SPAN LANG="en-au"><B><BR>
<FONT COLOR="#000080" SIZE=2 FACE="Arial">W:</FONT></B></SPAN><SPAN LANG="en-au"> </SPAN><A HREF="http://www.esc.net.au"><SPAN LANG="en-au"><B></B></SPAN><SPAN LANG="en-au"><B><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.esc.net.au</FONT></U></B></SPAN><SPAN LANG="en-au"></SPAN></A><SPAN LANG="en-au"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-au"><FONT SIZE=2 FACE="Arial"> << File: ATT14776630.txt >></FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"> </SPAN></P>
</BODY>
<!--[object_id=#staff.netspace.net.au#]--><P align=left><FONT face=Arial size=1>This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the organisation. Finally, the recipient should check this email and any attachments for the presence of viruses. The organisation accepts no liability for any damage caused by any virus transmitted by this email.</FONT></P></HTML>