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
AJ View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote AJ Quote  Post ReplyReply Direct Link To This Post Topic: stats
    Posted: 06 August 2003 at 8:42am

Can the stats of emails (forwarded, blocked, attempts etc...) be sorted out by domain? also can some domains be quarantined and some not?

thanks

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: 06 August 2003 at 11:50pm

AJ,

Second issue first.  Are you asking about source domain or destination domain?  And what build are you running?

First Issue.  If you are using ASP code to manage the quarantine, you can do almost anything with the quarantine.  If you want actual traffic statistics to be sorted, you need to parse the log files and what I am doing (not totally finished writing) is re-writing the logs into an SQL DB and using the same ASP code to sort things out.

As an example, the following SQL Statements will return the domain part of a from address that you can later sort on using a normal ordering command like   order_By = "Domain, MsgDate, EmailTo, Subject, RejectDetails"

NOTE: The variable "SearchQuery"  in this case is looking for a partial match in the from field.  I then decide how long a period I want to look at ... 1 hour 24 hours etc

SQL = "SELECT SUBSTRING(EmailFrom, CHARINDEX('@', EmailFrom) + 1, 100) "
SQL = SQL & "AS Domain, QuarID, EmailFrom, Subject, MsgDate, MsgID, RejectDesc, RejectDetails, EmailTo "
SQL = SQL & "FROM tblQuarantine, tblRejectCodes "
SQL = SQL & "WHERE EmailFrom LIKE '%" + Replace(SearchQuery, "'", "''") + "%' "
SQL = SQL & "AND (Deliver <> 1) "
SQL = SQL & "AND (Expire <> 1) "
SQL = SQL & "AND (tblQuarantine.RejectID = tblRejectCodes.RejectID) "
If SearchSpan = 1 Then
SQL = SQL & "AND (MsgDate >= DATEADD(hour,-1,getdate())) "
End If
If SearchSpan = 4 Then
SQL = SQL & "AND (MsgDate >= DATEADD(hour,-4,getdate())) "
End If
If SearchSpan = 8 Then
SQL = SQL & "AND (MsgDate >= DATEADD(hour,-8,getdate())) "
End If
If SearchSpan = 24 Then
SQL = SQL & "AND (MsgDate >= DATEADD(hour,-24,getdate())) "
End If
SQL = SQL & "ORDER BY " & order_By
Set rs = con.Execute(SQL)
RecordCount = rs.RecordCount

This, I believe, will work with access also but my design plan still has to parse the logs into the database and it is a fair amount of work for a non db guy like myself.

Regards,
Dan S. (Just a user)

Back to Top
AJ View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote AJ Quote  Post ReplyReply Direct Link To This Post Posted: 09 August 2003 at 10:34am

Thanks for the reply!  on the second issue we would like to quarantine some of the destination domains and some not.  (we're using V 1.2.0.190)

On the first issue:  we want to sort the stats but we're not sending the messages to quarantine, we're just rejecting them.  Do you know if the sender gets an undeliverable notification when the email is quarantined?  we like the "rejection mode" cause when its a false positive the sender gets an "undeliverable" notification.

 

 

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: 11 August 2003 at 1:41pm

AJ,

I will get the answer to the rejection notification .... I have a note on that issue but need to find it.

On the Quarantining of some domains but not others: .... That has not been implemented YET.  It may or may not be in the future ... 

Dan S.

 

Back to Top
George View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote George Quote  Post ReplyReply Direct Link To This Post Posted: 11 August 2003 at 2:46pm
Seems to me that if there is a domain that you don't want filtered for spam, don't list it in the local domains list and just leave the MX record for that domain pointing to the SMTP server instead of the SpamFilter server.
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: 12 August 2003 at 1:30am

AJ,

The sender WILL get a reject notification under all conditions.

Dan S.

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.224 seconds.