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

[Ken Crocker]

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" <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
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090821/61db9169/attachment.htm>