[rt-users] Reporting: List of new/open tickets?

[Kimberly McKinnis]

Cool. We're using 3.4.5, I don't see a dashboard, but this may be an excuse for an upgrade. Thanks guys :)

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of spark
Sent: Thursday, August 27, 2009 3:21 PM
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Reporting: List of new/open tickets?

Hi Kimberly,
We use dashboards to automate the emailing of new/open lists each 
morning. Perhaps that might work for you?

- Sean

Kimberly McKinnis wrote:
> I guess I should be more specific. Our PMs would like to have this info automated and emailed, instead of cutting and pasting it from the query builder in RT. Thanks!
> 
> -----Original Message-----
> From: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com] 
> Sent: Thursday, August 27, 2009 3:10 PM
> To: Kimberly McKinnis
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Reporting: List of new/open tickets?
> 
> Hello Kimberly,
> 
> Do you need script? In the RT web ui you can use Charts for that. As
> well, you can re-use code from the latest version of
> share/html/Search/Elements/Chart
> 
> 
> my $Query = "Queue = 'X'";
> 
> use RT::Report::Tickets;
> my $tix = RT::Report::Tickets->new( $session{'CurrentUser'} );
> my ($count_name, $value_name) = $tix->SetupGroupings(
>     Query => $Query, GroupBy => 'Status',
> );
> while ( my $entry = $tix->Next ) {
>     my $status = $entry->__Value( $value_name );
>     my $count = $entry->__Value( $count_name );
>     print "$status => $count\n";
> }
> 
> I think this code should work, but I'm not sure if SetupGroupings
> method is part of RT 3.8.4 or not. Implemented it recently to simplify
> things and make it possible to group by multiple columns.
> 
> On Fri, Aug 28, 2009 at 1:42 AM, Kimberly McKinnis<kmckinnis at tivo.com> wrote:
>> Before I attempt to reinvent the wheel, I was wondering if anyone had
>> written a reporting script that did something such as listing the numbers
>> and subjects of all open and new tickets. I found something on the wiki, but
>> it requires manual input of ticket numbers.
>>
>>
>>
>> I also have some rudimentary scripting using the RT pms, but any
>> pre-existing code would save time. Thanks!
>>
>>
>>
>> ~~
>>
>> Kimberly McKinnis
>>
>> System Operations Engineer
>>
>> Service Provider Division, TiVo Inc
>>
>> 408-519-9607
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
> 
> 
> 
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com