[rt-users] Closing all incidents by a specific Owner
Hello all, Is there a way (script/SQL) to close all incidents owned by one specific user? (mass closing) Regards, Tamas Szep
Re: [rt-users] Closing all incidents by a specific Owner
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:elac...@easter-eggs.com - http://www.easter-eggs.com
Re: [rt-users] Closing all incidents by a specific Owner
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