Logging recipient?

[MailScanner]

To get a list of top ten spam magnets out of the Mailwatch database:

select to_address, sum(isspam) as spam from maillog group by to_address
order by spam desc limit 10

Bart...

-----Original Message-----
From: MailScanner mailing list [mailto:MAILSCANNER at JISCMAIL.AC.UK] On
Behalf Of Mike Zanker Posted At: 01 April 2004 07:12 Posted To:
MailScanner
Conversation: Logging recipient?
Subject: Re: Logging recipient?


On 31 March 2004 17:30 -0600 Mike Kercher <mike at CAMAROSS.NET> wrote:

> You might suggest this to the developers of MailWatch as a feature 
> request. They already have quite a few nice reports.

Just installing MailWatch should be enough. You can then write a script
to extract and process all the spam entries from the database.

Mike.