Statistics since? |
Post Reply 
|
| Author | |
Wayne 
Groupie 
Joined: 29 August 2006 Location: Switzerland Status: Offline Points: 60 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Statistics since?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
|
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4106 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Wayne
Groupie
Joined: 29 August 2006 Location: Switzerland Status: Offline Points: 60 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
Desperado
Senior Member 
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Wayne
Groupie
Joined: 29 August 2006 Location: Switzerland Status: Offline Points: 60 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.242 seconds.