[rt-users] Closing all open tickets at once

[Ruslan U. Zakirov]

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.

				Ruslan.
> 
> 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>