Eric Tamme wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1Are 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: [EMAIL PROTECTED]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.
OpenResolveReport.pl
Description: Perl program
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
