How to discard obvious spam from daily email report
Posted: 05 Nov 2014 19:21
Daily spam reports are cluttered with lots of obvious spam emails. Here is how to discard obvious spam from daily email report.
Edit
to
You can change a.sascore value per your need.
run to see the result.
Edit
Code: Select all
/usr/local/bin/mailwatch/tools/Cron_jobs/quarantine_report.php Code: Select all
a.date >= DATE_SUB(CURRENT_DATE(), INTERVAL " . QUARANTINE_REPORT_DAYS . " DAY)
ORDER BY a.date DESC, a.time DESC";
Code: Select all
a.date >= DATE_SUB(CURRENT_DATE(), INTERVAL " . QUARANTINE_REPORT_DAYS . " DAY)
AND
a.isspam>0
AND
a.sascore<7
AND
a.spamblacklisted=0
ORDER BY a.date DESC, a.time DESC";
run
Code: Select all
/usr/local/bin/mailwatch/tools/Cron_jobs/quarantine_report.php