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 * 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 * 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. SF2DB is a parsing engine that generates a database that any query and/or reporting tool can be used to generate reports on..

Requirements - Windows 2000, XP, 2003, 2008 with 32 MB RAM available for SF2DB; recommend minimum 512MB total minimum system RAM. Intel Pentium 4 3.0 GHz or greater processor is recommend although any Intel Pentium will work for 32-bit executable. 64-bit OS Required for SF2DB_64.exe. Microsoft Data Access Components version 2.7 or greater 2.8SP1 (preferably) and Microsoft JET 4.0 SP8 (Only if MSAccess is used) depending on which data access method you want to use. The data access components and JET installations are included in the download package. SpamFilter version 3.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 a single email message into a single row of data stored in a database. This program has been evolving for over six years. It is extremely accurate, however, it's accuracy is not guaranteed in any way because the log files can change beyond our control. 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 at SF2DB version release time. Your license fee includes unlimited remote technical support and updates to the software for 1 yr.

Recommended SpamFilter Settings - It is recommended to parse your log files hourly using scheduled tasks and SQL IS Packages. To have SpamFilter generate hourly logs, you use the setting RotateLogsEveryNNhours=1 in SpamFilter.ini Additionally, SF2DB will log enhanced connection data that is provided when you use the AlwaysDoReverseDNSLookups=1 setting in SpamFilter.ini.

Reporting - You create your own queries and reports using your favorite database query and reporting tools.

Database Structures - SF2DB can create and store the following information on each email message processed by SpamFilter:
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 Database.rtf 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, ext. 102.

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