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

Emmanuel Lacour elacour at easter-eggs.com
Wed Nov 19 05:24:12 EST 2014

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

More information about the rt-users mailing list