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
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.047 seconds.

Copyright © 2002-2016 LogSat Software LLC - Sales: sales@LogSat.com
Contact Us