Spammed!

[RichH]

Hi,

This morning one of our OTRS queues was spammed with over 4000 bad messages. I was able to identify the bad messages by the sender's address.

I created a new ticket state named 'Spam' with a state type of 'Closed'.

I then used mySQL query browser to change all ticket with the customer_id equal to the sender to the state 'Spam':

update ticket set ticket_state_id = 10 where customer_id = 'sample@email.tst';

The tickets are no longer appearing in the queues ticket list, however in the Queue view top menu the count of all tickets in the queue still includes the 4000+ spam tickets:

QueueViewbanner.jpg

What can I do to correct this?

[jojo]

NEVER write on the database manually!!!! Better use GenericAgent

For your case now: delete the OTRS caches

[KimmoJ]

For future use, you could have just moved those tickets to the Junk queue, and have a scheduled job that goes through the Junk queue and erases the jobs in there. Optionally, leave them for a few weeks and check to see what's in there.