On a ticket we had the requester that activated an Out of office, as well as the Technician assigned to it. After a few days both these users also ran out of mailbox space.

We are pulling emails every 10 minutes. Now the ticket gets updated and it send out emails to both the requester and technician. (this happens with every email retrieved with the request number in the subject) Now you can calculate the impact it can cause on the system. I was able to stop it on 67000+ conversations.

Now I am sitting with 2 huge tables in the SQL db (MS SQL).

How can I do a complete cleanup on this ticket(s) including the attachments (logos) that it might have and is stored on the server's folder. Obviously I will have to filter it by ticket number and words in the subject (ex. Out of Office)

We use MS SQL as the SQL

Regards