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:[email protected]] > Sent: Thursday, August 27, 2009 3:10 PM > To: Kimberly McKinnis > Cc: [email protected] > 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<[email protected]> 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: [email protected] >> >> >> 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: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
