I am faced with about 7000 tickets in a queue. Was wondering if someone
could suggest a method to mass delete these junk tickets without going
through the web interface.
Also, is there a way I can protect my queues in future from such problems?
If changing the status of the tickets to “deleted” is sufficient, you should
be able to do a ticket search for all tickets with that requestor. At the
bottom of the list of tickets, there is a link to update all tickets. Then
change the status to delete.
As for preventing future problems, I think you want to block those e-mails
at your MTA. In my case, we only allow ticket creation for privileged users.
This prevents spam from entering RT very nicely, but may not be an appropriate
solution, if you have a large customer base that should be able to submit
RT tickets.
-AaronOn Tue, 10 Feb 2004, Hariharan wrote:
Hello
I am faced with about 7000 tickets in a queue. Was wondering if someone
could suggest a method to mass delete these junk tickets without going
through the web interface.
Also, is there a way I can protect my queues in future from such problems?
Will ‘change status to delete’ actually remove them from his database?
Sometimes you just want junk entries gone. Not archived.
This happened to us in RT2, and we had to manually delete tickets in mysql.
Opening up an email address to the internet without a list of procmail’d
allow senders (or something that does the same thing) is guarantee nowadays
to get spammed.
If changing the status of the tickets to “deleted” is sufficient, you should
be able to do a ticket search for all tickets with that requestor. At the
bottom of the list of tickets, there is a link to update all tickets. Then
change the status to delete.
As for preventing future problems, I think you want to block those e-mails
at your MTA. In my case, we only allow ticket creation for privileged users.
This prevents spam from entering RT very nicely, but may not be an appropriate
solution, if you have a large customer base that should be able to submit
RT tickets.
-Aaron
On Tue, 10 Feb 2004, Hariharan wrote:
Hello
I am faced with about 7000 tickets in a queue. Was wondering if someone
could suggest a method to mass delete these junk tickets without going
through the web interface.
Also, is there a way I can protect my queues in future from such problems?