[rt-users] Closing all incidents by a specific Owner

[Emmanuel Lacour]

On Wed, Nov 19, 2014 at 11:11:53AM +0100, "Tamás, Szép" wrote:
> Hello all,
> 
> Is there a way (script/SQL) to close all incidents owned by one specific
> user? (mass closing)
> 


you can use the WEB UI, search for all tickets wiht this owner, then in
the search results, click on "Bulk update"  and change status for all
ticket at once.

on command line, you can use the following:


you can also use the RT cli (http://requesttracker.wikia.com/wiki/CLI),
or rt-crontool:

something like:

./bin/rt-crontool --search RT::Search::FromSQL --search-arg "Owner = 'THE OWNER'" --action RT::Action::SetStatus --action-arg "resolved"


or even write a small perl script using RT API



-- 
Easter-eggs                              Spécialiste GNU/Linux
44-46 rue de l'Ouest  -  75014 Paris  -  France -  Métro Gaité
Phone: +33 (0) 1 43 35 00 37    -   Fax: +33 (0) 1 43 35 00 76
mailto:elacour at easter-eggs.com  -   http://www.easter-eggs.com