Print Page | Close Window

Feature Request: Passthrough DB

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5314
Printed Date: 16 December 2025 at 10:50pm


Topic: Feature Request: Passthrough DB
Posted By: sgeorge
Subject: Feature Request: Passthrough DB
Date Posted: 23 August 2005 at 12:28pm

I am extremely pleased with this software and I think it's a great product.

I have a feature request that I feel would be useful, and I am curious as to whether others feel it would be useful as well - a "Pass-through DB", or simply the ability to store all messages that are NOT quarantined to a separate database.

The reason for such a request is as follows:

  • I work in an organization that receives much Spam, as we all do.
  • SpamFilter does a great job of filtering-out the vast majority of Spam, but for the remaining spam that gets through, I need a strategy for removing additional spam by adding filters for the spam messages that we receive in the greatest abundance.
  • Having a database record of all accepted emails would make it rather easy to browse the database and find repeated messages of similar content, and block those unwanted messages that are sent the most often.
  • this would be more effective than making RegEx filters for spam messages that may be sent less than 5 times, and never again.

Thanks for considering.  If people would add their own thoughts I would appreciate it.




Replies:
Posted By: pcmatt
Date Posted: 23 August 2005 at 9:08pm

I have a program that I wrote (SF2DB.exe SpamFilter Logs 2 Database) that runs on Windows servers and parses the SpamFilter log files combining all of the log entries for each email message into your favorite database.  Once in the database you may perform queries, write reports and analyse both rejected and approved email transactions.  Currently I parse all log files after midnight each night for the previous day and therefore am able to maintain an detailed database reporting system on all SpamFilter emails processed that is always current as of midnight the night before.  I use asp html reports and crystal reports to report on the data.

If you are interested in trying this program send an email to matt at idp.net. 



-------------
-Matt R


Posted By: pcmatt
Date Posted: 01 September 2005 at 11:11pm

SF2DB.exe SpamFilter Logs 2 Database that runs on Windows servers and parses the SpamFilter log files combining all of the log entries for each email message into your favorite database.  Once in the database you may perform queries, write reports and analyse both rejected and approved email transactions.  Currently I parse all log files after midnight each night for the previous day and therefore am able to maintain an detailed database reporting system on all SpamFilter emails processed that is always current as of midnight the night before.  I use asp html reports and crystal reports to report on the data.

Info and download link:

http://www.ServerBoss.com/SF2DB - http://www.ServerBoss.com/SF2DB

 



-------------
-Matt R


Posted By: sgeorge
Date Posted: 02 September 2005 at 7:52am
Great, I'm looking forward to trying this out!



Print Page | Close Window