Eric Tamme wrote:
-----BEGIN PGP SIGNED MESSAGE-----
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
Community help: http://wiki.bestpractical.com
Commercial support: firstname.lastname@example.org
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
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.
OpenResolveReport.pl (5.07 KB)