SV: mailing Quarantine "dump"

[Jan Agermose]

    [ The following text is in the "iso-8859-1" character set. ]
    [ Your display is set for the "US-ASCII" character set.  ]
    [ Some characters may be displayed incorrectly. ]


Im looking at this:

 

select timestamp, from_address, to_address, subject from maillog where
to_address like '%@thedomain.com and (isspam = 1 or ishighspam = 1) order
by timestamp desc limit 10;

 

(the limit 10 replaced by “today limiting” J )

 

But Im afraid I need to check all the bit’ ?

 

isspam | ishighspam | issaspam | isrblspam | isfp | isfn |
spamwhitelisted | spamblacklisted

 

 

Mvh

Jan

 

________________________________________________________________________________

[IMAGE]

Jan Agermose
CEO Conviator

Tel. +45 35 266 460
Human Resource profile

 

 

 

 

 

 

 


________________________________________________________________________________


Fra: MailScanner mailing list [mailto:MAILSCANNER at JISCMAIL.AC.UK] På
vegne af Jan Agermose
Sendt: 27. juni 2005 18:43
Til: MAILSCANNER at JISCMAIL.AC.UK
Emne: mailing Quarantine "dump"

 

Hi

 

I would like to dump quarantine data to domain admins once a day to make
it possible and easy to check if some false positives should be in the
quarantine. I was looking in the MySQL database “mailscanner”
and looking at the table “maillog” – but…
I’m missing a “status” bit or something to tell me the
mail was put in quarantine or am I missing something?

 

 

Mvh

Jan

 

________________________________________________________________________________

 

[IMAGE]

Jan Agermose
CEO Conviator

Tel. +45 35 266 460
Human Resource profile

 

 

 

 

 

 

 

 

------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the Wiki (http://wiki.mailscanner.info/)
and the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).

Support MailScanner development - buy the book off the website!
------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the Wiki (http://wiki.mailscanner.info/)
and the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).

Support MailScanner development - buy the book off the website!

    [ Part 2, "image001.gif"  Image/GIF  732bytes. ]
    [ Unable to print this part. ]