Statistics since?
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=6308
Printed Date: 15 July 2025 at 3:32am
Topic: Statistics since?
Posted By: Wayne
Subject: Statistics since?
Date Posted: 28 November 2007 at 2:58am
|
Hi The "Statistics" tab is very useful and interesting, but where can I find out since when this statistics are recorded? Is it the file creation date from the database file? Thanx Wayne ------------- SF4.5.0.1-beta |
Replies:
Posted By: LogSat
Date Posted: 29 November 2007 at 11:35pm
|
Wayne, SpamFilter retrieves that info from the quarantine database if you are using that functionality. The following query returns a list of how many emails in the quarantine have been blocked by the various rules: SELECT tblQuarantine.RejectID, tblRejectCodes.RejectDesc, COUNT(tblQuarantine.RejectID) AS Total FROM tblQuarantine INNER JOIN tblRejectCodes ON tblQuarantine.RejectID = tblRejectCodes.RejectID GROUP BY tblQuarantine.RejectID, tblRejectCodes.RejectDesc ORDER BY TOTAL DESC ------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: Wayne
Date Posted: 30 November 2007 at 2:23am
|
Hi Roberto Thanx for your reply! But I store only 7 days in the quarantine database and so we have only 20'000 records into it. But at the statistics tab "Emails blocked" we have much more records and it would be very interesting since when. Regards Wayne ------------- SF4.5.0.1-beta |
Posted By: Desperado
Date Posted: 30 November 2007 at 2:38pm
|
Wayne,
I believe the statistics you are referring to are the ones that are storred in the ini file. What I tend to do is clear those stats once a monthe so that *I* know how long the stats were maintained. ------------- The Desperado Dan Seligmann. Work: http://www.mags.net Personal: http://www.desperado.com |
Posted By: Wayne
Date Posted: 01 December 2007 at 7:55am
|
Desperado Yeah, you're right!  I never would have believed to look for this stats in the ini file. Now I can reset this counters and can restart them every month! Thank you very much!  Regards Wayne ------------- SF4.5.0.1-beta |