[rt-users] Closing all open tickets at once

Ruslan U. Zakirov cubic at acronis.ru
Mon Apr 26 05:31:09 EDT 2004

Swinkels, Marcel wrote:
> Hi,
> is there a way to close all open tickets directly using SQL? I am
> currently testing our RT setup and we have 9855 tickets open at this
> moment. Closing them all using the mass-update option in RT takes hours
> and causes time-outs while using the webinterface. Is there a way I can
> close them all using plain SQL (something like UPDATE Tickets SET
> status='closed' WHERE status='open' ?)
Plain SQL only if know what you are doing, do you?

Attached script could be used as template. It's set status='deleted' by 
requestor's email address.

> Regards,
> Marcel Swinkels
> chello abuse
> UPC Nederland
> abuse at chello.nl 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.
> http://bestpractical.com/services/training.html
> Sign up early, as class space is limited. 

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: delete-by-requestor
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040426/6b6b795d/attachment.ksh>

More information about the rt-users mailing list