Allow intranet users to search a SPAM.NSF database for false positives

Difficult, unless you want to modify those mail: you'd have to add Reader-fields. Not very practical. You migth allow some sort of Search, I'd say through a browser on your Intranet. You can hide more Notes-features using the HTTP-server.

Furthermore, how is Mark Johnson going to find mail that was addressed to Marc Johanson? I think it's a job for some poor person, under the supervision of the HR department?

I agree that this is going to be difficult due to authentification issues. Web based for sure, with just a script that automatically searches based on login name. No direct connect to the DB itself, just a search agent.

the IIS based mail name may not be the same as for Notes, so Sjef is correct that you would need a translation table that would need to be maintained.

I hope this helps !

Thank you for the input.

I’m surprised it is not as straightforward as I though it would be; thinking some kind of .NET database connector would be able to do the job.

Maybe the database can be exported then searched? Or surely a notes script itself  on the clients could do the job?

Or  a ODBC -> NOTES  driver ( http://www.csc.fi/cschelp/sovellukset/stat/sas/sasdoc/sashtml/win/z0624057.htm#z0624673) to allow IIS to access the database?

We can think of lots of ways to get this done, but tell us first how you are going to prevent that the wrong user reads the wrong mail?

Domino is configured with ‘full name  lookup’ & ‘address must exist in domino directory’ so only valid email addresses should get to the router; to then be redirected to SPAM.nsf.

When I user logs into the Intranet a session variable is set with their email address. I was thinking this variable could be used to search the database.

These users are also authenticating on the Domino server, when they use that server from the Intranet? I think the only way is to build an application that searches for only their name. If you can pass the name in the URL, so much the easier.

We tried this with a notes DB and performance was horrible. We tried to have an agent that updated the readers fields on new messages but took a long time to run.

We use brightmail quarantine where I am at now and basically it is a MYSQL database the messages get e-mailed into via SMTP and then a program runs to look at the SMTP address and compare it with those in a User table. Then it copies items from the body, subject and other fields into a table and inserts the user key. Then when they log in use just do normal SQL queries.

But as mentioned above we still have issues with the app maintaining the user's table and seeing other names when logging in

Agree with brwwiggins.. familiar with SPAMJAM, that does allow users to find their quarantined spam, but this spam protector allows all spam in and then filters it per user to allow users to manage their own spam.  So it was a performance killer.  

However, I found the separate boxes to be really helpful in curtailing spam, with minimal cost and administration:
http://www.gessworks.com/WebSite.nsf/page/mimeshield
http://www.trimmail.com/products/
http://www.barracudanetworks.com/ns/products/

Or integration with SpamAssassin
http://www.openntf.org/Projects/pmt.nsf/ProjectHome?ReadForm&Query=SpamAssassin%20Integration

Sorry for the delay. I’d like to avoid using a separate appliance - WatchGuard is OK.

sjef_bosman users are only authenticating against the Active Directory not domino.

The email address could easily be passed in a URL to the domino server. I simply do not know domino to understand how this could be used / domino scripts to execute etc.

I appreciate your help.

i'm keen to get your advice on this pls?