[SOLVED] Batch delete of specific emails in account

[jsabater]

Hello everyone!

I have an account that has been the target of a spam attack, with over 22.000 spam emails now in the inbox folder. I am trying to find a way to get a list of all messages, filter them with the usual grep/cut/sed/awk tools and get a list of message IDs that I can, again, batch process with zmmailbox and mark them as junk.

I have found the command to mark them as junk (which will also move them into the junk folder, hopefully), but I have not found a way to list all the emails in a given account/folder so that I can filter them and get the IDs.

Any hints? This is a Debian Etch 32 bits box with ZCS Network Edition 5.0.7 and 1200 accounts from one of my customers.

Thanks in advance.

[alexkelly]

This is a bit time consuming...but the only way I know of to do this is with zmmboxsearch

zmmboxsearch -d /tmp/somedir -m account@domain.com -l25000 -q "in:\"Inbox\""

This will dump (-d) the messages that match the query (-q) for the mailbox (-m) with a limit of 25000 results returned.

From there, you will have all the messages in the /tmp/somedir that will be named:
Sequence#_uuid_messageid
So, if you were able to fine-tune the problems with the search, you will have all the message ids to get rid of. Otherwise, you will have all messages that you can then go through w/ normal command-line tools, and then make a list of the message IDs that you want to get rid of.

From that you can then use zmmailbox to operate on the specific message ids. So, if you want to remove items, you can do:

zmmailbox -z -m account@domain.com di itemid itemid itemid

[jsabater]

Thanks for the information. I managed to obtain the dump of messages and then, by a lot of greps, cuts, etc, get the IDs and, finally, process them.

Gotta say that, in the beginning, I was confused and was trying to get it done with the zmmailbox search command, but I could not manage to. Do you know whether this command would do the job that zmmboxsearch did, too?

Thanks for your help. Very much appreciated.