[rt-users] RT reporting - Mean time to resolution

[Chris Crow]

Eric Tamme wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Are there any "canned" reports that exist for RT besides whats in the
> "tools" section?  Im looking for some high quality reporting - our
> support Mgr asked me if this had a "mean time to resolution" report..
> and a "mean time to resolution by priority"
>
> I know that I can go into the database and run sql queries, i just
> wanted to know if there were some predefined queries, or reporting
> addons anywhere?
>
> Thanks
> - --
> Eric Tamme
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFIbPVi7CXjaJSx184RAptIAJ9iScvOUasuQiz6rE8QwigeJVEp1QCgutqV
> j43HgV9/jtCpUD8vwU2iRBQ=
> =OP4N
> -----END PGP SIGNATURE-----
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>   

I built a really ugly script that accepts query string from a browser 
and prints out average time for resolution and open.

It is a total hackjob, but your welcome to mess with it. Edit the file 
and take a look at the comments. You will need to change the username 
and password to connect to your rt database.

You install the script by putting it in your cgi-bin directory and 
calling: 
http://<serverip>/cgi-bin/OpenResolveReport.pl?datefrom=2008-07-01&dateto=2008-07-07 


You can change the datefrom and dateto variables above to fit your needs.

Also, I DID NOT SANITIZE THE SQL INPUT, SO THIS IS A HUGE SECURITY RISK, 
AT THE VERY LEAST, USE A USER ACCOUNT THAT ONLY HAS SELECT PERMISSIONS.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenResolveReport.pl
Type: application/x-perl
Size: 5190 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080707/4f8036cb/attachment.bin>