RT2 ticket deletion

RT Users
1

Hi,
Over the weekend we got around ~16000 bounced messages. They are all the same email, so would anyone have a script to do this large of a batch update or would a simple mysql command line update to the Tickets.Status var work?

Thanks,
Mitchell
henderson@wustl.edu

2

Hi,
Over the weekend we got around ~16000 bounced messages. They are all the
same email, so would anyone have a script to do this large of a batch
update or would a simple mysql command line update to the Tickets.Status
var work?

With RT2, you could do:

/path/to/rt/bin/rt2 --id=1-16000 --status=dead

to kill all tickets numbered from 1 to 16000.

Binand

3

Hi,
Over the weekend we got around ~16000 bounced messages. They are all the
same email, so would anyone have a script to do this large of a batch
update or would a simple mysql command line update to the Tickets.Status
var work?

With RT2, you could do:

/path/to/rt/bin/rt2 --id=1-16000 --status=dead

to kill all tickets numbered from 1 to 16000.

If any valid tickets came in the middle however, this would kill them too. Assuming you don’t have scrips you want triggered by the status change (with 16,000 I doubt you do) a simple sql query would do it:
UPDATE tickets SET status=‘dead’ WHERE creator=12345;
12345 is the id in the user’s table -
SELECT id FROM users WHERE emailaddress=‘spammer@example.com’;

-fr.

Feargal Reilly,
Systems Administrator,
The FBI.