Drew, Fran,
Is there anything unique to this scrip per RT version? In otherwords,
will it work on 3.6.4 as well as 3.8.4?
Kenn
LBNL
On 8/21/2009 10:42 AM, Drew Barnes wrote:
To second Fran, I have also been using this script in production for a while
now and have found it to be a good reporting tool for management.
We use it both on the command line, and with a wrapper to fit RT's look and
feel. If needed, I would be happy to share that off list.
On 8/21/09 12:48 PM, "Fran Fabrizio" <[email protected]> wrote:
I've attached a script I've developed over the summer to help me produce
time worked reports for my staff. Its features are:
# FEATURES
# - Produces a simple text report of the number of minutes worked per
# person per ticket in a given datetime range for all tickets that
# experienced > 0 minutes worked in that time period
# - Allows user to specify one or more queues to include in the ticket
# search
# - Assumes start and end datetimes entered in local time and adjusts for
# GMT which is RT's internal representation (but see --gmtime flag)
# - Correctly calculates time one person puts onto another person's ticket
# - Correctly calculates TimeWorked when directly updated via the Basics or
# Jumbo ticket update page as well as when added to a comment or reply
# - Optional --debug mode for verbose output
# - Basic --help text display
# - Uses RT's API (does not query database directly)
The script is pretty well documented so most questions should be
answered within. For usage, run "timeworked.pl --help". There is one
line within the script, the "use lib" line, that may need to be edited
before it'll work for you - I've noted this in the script documentation.
I'd certainly like to get feedback on the script, to see if this is
useful for others. It also could use more validation/testing - I've
been using and developing it for a while and I think it's doing pretty
well now, but I only have so much data and so many scenarios to test
against in my own RT install. Also, in the interest of full disclosure,
I should point out that it's my first RT API script. :-) Comments and
suggestions very welcome.
Thanks,
Fran
_______________________________________________
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
