[rt-users] Contributed script: A time worked reporting tool

[Drew Barnes]

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" <fran at cis.uab.edu> 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

-- 
Drew Barnes
Applications Analyst
Network Resources Dept.
Raymond Walters College