Closing all incidents by a specific Owner

RT Users
1

Hello all,

Is there a way (script/SQL) to close all incidents owned by one specific
user? (mass closing)

Regards,
Tamas Szep

2

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@easter-eggs.com - http://www.easter-eggs.com

3

Thank you very much, I will try one of those.

Tamas> 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