Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Stats
  FAQ FAQ  Forum Search   Register Register  Login Login

Stats

 Post Reply Post Reply
Author
kspare View Drop Down
Senior Member
Senior Member


Joined: 26 January 2005
Location: Canada
Status: Offline
Points: 334
Post Options Post Options   Thanks (0) Thanks(0)   Quote kspare Quote  Post ReplyReply Direct Link To This Post Topic: Stats
    Posted: 05 August 2005 at 2:54pm
What are people doing to provide stats to their customers? In the way of showing how many emails were recieved etc amoutn of spam etc etc
Back to Top
Alan View Drop Down
Groupie
Groupie


Joined: 06 May 2005
Location: United States
Status: Offline
Points: 43
Post Options Post Options   Thanks (0) Thanks(0)   Quote Alan Quote  Post ReplyReply Direct Link To This Post Posted: 05 August 2005 at 5:14pm
Sawmill
Back to Top
Derk View Drop Down
Groupie
Groupie


Joined: 26 January 2005
Location: United States
Status: Offline
Points: 39
Post Options Post Options   Thanks (0) Thanks(0)   Quote Derk Quote  Post ReplyReply Direct Link To This Post Posted: 05 August 2005 at 6:38pm

I wrote a Cold Fusion user interface and I have a scheduled task that runs every 15 minutes.  It searches through the spamfilter.ini for "EmailsBlocked", extracts the value, and updates a table in the database.  I then display the variable on the login page.  Here is my code:


<cfset thepath="C:\Program Files\SpamFilter\">
<cfset thefile="SpamFilter.ini">

<cffile action = "read" file = "#thepath##thefile#" variable="spamstats">

<cfset blockedstart=findnocase("EmailsBlocked=",spamstats)+14>


<cfset blockedend=(findnocase("EMailsForwarded", spamstats, blockedstart)-blockedstart)-2>

<cfquery name="setblocked" datasource = "#application.dsource#">
UPDATE statistics
SET blocked = #mid(spamstats, blockedstart, blockedend)#,
lastupdated = #now()#
where ID=1
</cfquery>

Back to Top
pcmatt View Drop Down
Senior Member
Senior Member
Avatar

Joined: 15 February 2005
Location: United States
Status: Offline
Points: 116
Post Options Post Options   Thanks (0) Thanks(0)   Quote pcmatt Quote  Post ReplyReply Direct Link To This Post Posted: 01 September 2005 at 11:09pm

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.

Info and download link:

http://www.ServerBoss.com/SF2DB

 

-Matt R
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.330 seconds.