Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Quarentine Lookup
  FAQ FAQ  Forum Search   Register Register  Login Login

Quarentine Lookup
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
wes View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote wes Quote  Post ReplyReply Direct Link To This Post Topic: Quarentine Lookup
    Posted: 07 October 2003 at 5:16pm

Would it be possible to seperate the username from the domain name in the "from" column of the quarentine list. (using access database)  Right now I have to search the log files if our client neeeds a rejected e-mail and only have a domain name.  I know they should get more info before they call but they don't.  Just a wish.  Thanks Wes
Back to Top
Alec View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Alec Quote  Post ReplyReply Direct Link To This Post Posted: 07 October 2003 at 5:44pm
Open the database in Access and use VBA to parse the addresses.
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104 		Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 09 October 2003 at 10:57pm

Wes,

That is part of why we developed a web interface for the quarantine, to allow each end user to access their own quarantined emails.

If that is now an option for you, rather than looking at logfiles it would be simpler to query the database for the sender's emails. You can perform partial searches in databases using the "LIKE" SQL operator.

Roberto F.
LogSat Software
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 October 2003 at 3:22am

Wes,

Please elaborate on the lookup problem.   I have an interface for our customers that looks something line the image in the link below:

http://spamman.ipresolve.com/test/dadmin.jpg

It actually has several more options now.  I also have a very in depth interface for our Support Staff that allows them to search for almost anything they need to.  It is a very rare deal that they need to go into the logs to find something.

I also have modified the listspam.asp to allow sorting by from address or from domain using a custom query as follows:

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

The case statement for sorting is modified as follows:

 Select Case order_By
  Case "EmailTo"
   order_By = "EmailTo, MsgDate, Subject, EmailFrom"
  Case "Subject"
   order_By = "Subject, MsgDate, EmailFrom, EmailTo"
  Case "EmailFrom"
   order_By = "EmailFrom, MsgDate, EmailTo, Subject"
  Case "Domain"
   order_By = "Domain, MsgDate, EmailTo, Subject, RejectDetails"
  Case "MsgDate"
   order_By = "MsgDate, EmailFrom, Subject, EmailTo"
  Case "DESC-MsgDate"
   order_By = "MsgDate DESC, EmailFrom, Subject, EmailTo"
 End Select

These are for example only .... you can do nearly anything you want just by setting up custom queries.

Dan S.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.160 seconds.

Copyright (c)2002-2021 LogSat Software LLC - Sales: sales@LogSat.com
Contact Us