[rt-users] Closing all open tickets at once

Swinkels, Marcel MSWINKELS at UPC.NL
Mon Apr 26 05:10:00 EDT 2004


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' ?) 


Marcel Swinkels
chello abuse
UPC Nederland
abuse at chello.nl 

More information about the rt-users mailing list