Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - MySql Statistical filter match query
  FAQ FAQ  Forum Search   Register Register  Login Login

MySql Statistical filter match query
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
keizersozay View Drop Down
Groupie
Groupie
Avatar

Joined: 26 January 2005
Location: United States
Status: Offline
Points: 77 		Post Options Post Options   Thanks (0) Thanks(0)   Quote keizersozay Quote  Post ReplyReply Direct Link To This Post Topic: MySql Statistical filter match query
    Posted: 15 November 2004 at 12:13pm

Is there an easy way to see which messages are blocked by the Bayes filter? Using the quarantine viewer in spamfilter is tedious and I can’t seem to find anything with a reject id of 14, which I believe is the id for the bayes filter... (when I run the other MySql query posted by Roberto it says that I do have some messages rejected by the statistical filter match.)

 

Anyone know of a mysql query?
Back to Top
keizersozay View Drop Down
Groupie
Groupie
Avatar

Joined: 26 January 2005
Location: United States
Status: Offline
Points: 77 		Post Options Post Options   Thanks (0) Thanks(0)   Quote keizersozay Quote  Post ReplyReply Direct Link To This Post Posted: 15 November 2004 at 1:55pm

SELECT     tblMsgs.MsgId, tblMsgs.Msg
FROM         tblQuarantine INNER JOIN
                      tblMsgs ON tblQuarantine.MsgID = tblMsgs.MsgID and tblQuarantine.RejectID = 14
GROUP BY tblMsgs.MsgID;

 

This seems to be working for me.
I use the mysql control center to run the queries so that they are easier to read.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.125 seconds.

Copyright (c)2002-2021 LogSat Software LLC - Sales: sales@LogSat.com
Contact Us