Closing all open tickets at once

RT Users
1

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

Regards,

Marcel Swinkels
chello abuse
UPC Nederland
abuse@chello.nl

2

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.

delete-by-requestor (1005 Bytes)