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

[Fran Fabrizio]

Ken>  I didn't test on earlier versions, but I suspect that it's pretty 
safe throughout the 3.x series, because the only things it really 
depends on are a few fields in the Transactions table that I think have 
all been around a long time (OldValue, NewValue, TimeTaken, ObjectID, 
etc...) and things from the Ticket object that have been around even 
longer (OwnerID, etc...)  Maybe one of the developers can comment about 
how far back you'd have to go before one of those isn't around.

Allen>  I'll work with you off-list to patch up the warning you are 
seeing, thanks for reporting.

Drew>  I'd like to see what you've done to integrate it into the RT 
interface - can you share that off-list with me?

Thanks all,
Fran

Ken Crocker wrote:
> 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
>>>     
>>
>>   


-- 
Fran Fabrizio
Senior Systems Analyst
Department of Computer and Information Sciences
University of Alabama at Birmingham
http://www.cis.uab.edu/
205.934.0653