SF2DB TM - SpamFilter* Logs 2 Database Processor
by Integrated Data Processing, Inc.

Register and Download FREE 30 Day Demo
Purchase SF2DB Log File Processor
Customer Service Logon

Introduction - SF2DB was written to address the need for accurate and detailed reporting on all email log activity created by Logsat's SpamFilter ISP * SMTP program. Other log reporting is generic and provides only cursory information. SF2DB provides a detailed report on EVERY important email message processed and logged by Logsat's SpamFilter ISP * program. By compiling log information into detailed data, a wealth of information is available including statistics, complete analysis and database formatted auditing information. A multitude of flexible queries and reports can be designed from the data that SF2DB creates.

Requirements - Windows 2000, XP or 2003 with 16 MB RAM available for SF2DB; recommend minimum 512MB total minimum system RAM. Intel Pentium 4 1.7 GHz or greater processor is recommend although any Intel Pentium will work. Microsoft Data Access Components version 2.7 or greater 2.8SP1 (preferably) and Microsoft JET 4.0 SP8 or greater depending on which data access method you want to use. The data access components and JET installations are included in the download package. SpamFilter ISP version 2.x.x or greater. ODBC compliant database compatible with MS Access or MS SQL Server databases.

Accuracy -

SF2DB is a highly sophisticated set of algorithms that combines varying numbers of log file entries for an email message into a single row of data stored in a database. This program has been evolving for over three years. It is extremely accurate, however, it's accuracy is not guaranteed in any way. SpamFilter software is being changed and updated on a regular basis and each version of SF2DB is tested against only the latest version of SpamFilter log files. Errors can be caused by backup programs locking SF2DB from file access it needs, hard drives can run out of space, operating systems can malfunction and hardware glitches can occur all causing undesirable results. It is critical that you monitor your data for consistency and to pin point issues that could come up. Report all problems, bugs, errors you can't resolve as well as your suggestions to matt@idp.net.

Reporting - You create your own queries and reports using your favorite database query and reporting tools. If you are interested, please let us know as we have and may offer separately add-on Web based and/or Windows based Report Generators.

Database Structures - SF2DB can create and store the following information on each email message:
LogID - Unique Key.
SRS - SpamFilter Server Name or reference.
RDomain - Recipient Domain.
LDate - Email Processing Start Date
LTime - Email Processing Start Time
LFullDate - Email Processing Start Full Date and Time
LDOW - Email Processing Start Day of Week
LMonth - Email Processing Start Month
ThreadID - SpamFilter Thread ID
SourceIP - Source IP Address of Sending System
SourceHostName - Source Host Name of Sending System
SourceCountry - Source Country of Sending System
Sender - Sender Email Address
Recipient - Recipient Email Address
SFAction - Result of SpamFilter checks 0 = Incomplete Data, 1 = Accepted, 2 = Rejected/Quarantined
Reason - Reason if Rejected, see SFLRejectCodes Rejection codes table. Note SF2DB uses its own table of rejection codes that does not correspond exactly to SpamFilter's tblRejectCodes.
Message - MAPS or Primary Email Disposition Message
Queued - Was queued?
Delivered - Was Delivered? (NOTE: NOT CURRENTLY SUPPORTED)
Complete - SF2DB processing complete?
CompletedTime - Full Date and Time Email Checking by SpamFilter was completed (to the point where the message was either queued or rejected/quarantined.
Keywords - Keyword or phrase that failed this email message.
SPFCheck - SPF Policy/Record if one was found.
AutoIPBlock - This message caused IP to be added to Auto Block List?
SURBLEntry - SURBL Value that caused message to be blocked
Virus - Virus that email message contained.

Complete data structures are documented in SF2DB.mdb; documentation for the MS Access file in AccessDatabase.rtf; and the SQL data structures in SpamFilterLogs.sql. All of these files are included in the demo download.

Technical Support - For support on SF2DB please send an email to matt@idp.net or support@serverboss.com. You may also call 800-878-0790 and ask for Matt.

* SpamFilter ISP is a trademark of Logsat Software and is not included.