Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Statistics since?
  FAQ FAQ  Forum Search   Register Register  Login Login

Statistics since?

 Post Reply Post Reply
Author
Wayne View Drop Down
Groupie
Groupie
Avatar

Joined: 29 August 2006
Location: Switzerland
Status: Offline
Points: 60
Post Options Post Options   Thanks (0) Thanks(0)   Quote Wayne Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
Wayne View Drop Down
Groupie
Groupie
Avatar

Joined: 29 August 2006
Location: Switzerland
Status: Offline
Points: 60
Post Options Post Options   Thanks (0) Thanks(0)   Quote Wayne Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Wayne View Drop Down
Groupie
Groupie
Avatar

Joined: 29 August 2006
Location: Switzerland
Status: Offline
Points: 60
Post Options Post Options   Thanks (0) Thanks(0)   Quote Wayne Quote  Post ReplyReply Direct Link To This Post Posted: 01 December 2007 at 7:55am
Desperado

Yeah, you're right! Big%20smile 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! Clap

Regards
Wayne
SF4.5.0.1-beta
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.109 seconds.