Delete Tickets

RT Users
1

Hi,

There's any way to delete all tickets that Subject contains a

specific word?

Can I do an update to my database like "UPDATE Tickets SET

Status=‘delete’ WHERE Subject LIKE ‘%word"’ and (Status=‘new’ or
Status=‘open’);" ? I have 7000 tickets to delete.

Thanks!

(Sorry for my bad english)

2

Hi,

There's any way to delete all tickets that Subject contains a

specific word?

Can I do an update to my database like "UPDATE Tickets SET

Status=‘delete’ WHERE Subject LIKE ‘%word"’ and (Status=‘new’ or
Status=‘open’);" ? I have 7000 tickets to delete.
It’s better to use API for such things.
You can use simple script like attached one to do such things.

Thanks!

Best regards, Ruslan.

rt-bulk-action.pl (581 Bytes)