Howto delete incoming email with virus

[Victor Rosillo]

We got incoming spam emails with virus in them that were not filtered by the email server.
how can we delete them from the sugar mysql database?

[paikmoses]

We got incoming spam emails with virus in them that were not filtered by the email server.
how can we delete them from the sugar mysql database?

Do cross-check with your hostinng provider, they might be having some spam checkers.

Regards,

[Victor Rosillo]

The queswtion is:
how can we delete emails that have virus once they are inside the mysql sugarcrm database?

[paikmoses]

Try running this query:

DELETE * FROM `emails` WHERE 'type' = 'out' ;

HTH.

Regards,

[Victor Rosillo]

Will this sql to delete email will also delete the Note associated to it, to the email?; for instance, I see that each incoming email that has graphics on it, or an attachment, gets automatically a Note that contains the attachement or graphic, I want to delete both the email and the note and the graphic or attachment. Please post sql to do this.