Search all mail databases for a word

Hi. Is there a way to search all mail databases on a server for a particular word? An agent or some other way? Thanks for your help.

Subject: Search all mail databases for a word

Bob,

Yes, there are many ways.

You could make a domain full text index and include all mail files.

You could make an agent which trawls through all mail files.

Both are a pain so you’d only do one or the other if you needed to. If this is a one-off event I would definitely go with option #2.

regards,

raphael

Subject: RE: Search all mail databases for a word

Thanks for your help. I know how to write an agent for a database, but not how to write an agent tha would trawl through all mail files. Is that something hard to do? Thanks.

Subject: RE: Search all mail databases for a word

Bob,

It’s not too hard but if you have more than a handful of mail files, and if any of them are biggish (500mb?) then you’ll start running into timeout issues and access issues, no doubt. Managing the code/process is harder than the code itself by a long shot.

I knew I was in trouble once when I realized the code was taking 24 hours to complete …

regards,

raphael

Subject: RE: Search all mail databases for a word

Thanks for your advice Raphael. I might just have to go with a 3rd party for this. Thanks. Bob