Is there a Way to Search an Entire Exchange 2007 Database?

I have a client that is in need of searching the entire Exchange Server for emails

that come from a certain domain.

The Database is 300 Gigs in Size and approx 38 mailboxes.

Is there a way for this to be done?

Cjoego
Joseph SalazarVice President - Senior IT ConsultantAsked:
Who is Participating?
 
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
The way I do this in MariaDB/MySQL is just run the database dump tool, filtered through a script which prepends every row with database + table names, then grep/search for strings of interest.

Crude + effective.

Likely there's some tool which also dumps the Exchange database... if Exchange actually has an SQL database... which, as I'm thinking right now... is doubtful.

More likely Exchange has some sort of custom file system, like Dovecot's mdbox for optimizing message storage.

So, you'll either have to decode all these files using some custom code or use some sort of command line IMAP test tool, then feed in a list of user/pass credentials, to search every user's email for some string.

Likely the first option (custom code to search actual files) will run much faster.
0
 
CESNetwork AdministratorCommented:
0
 
AlanConsultantCommented:
Hi Joseph,

You could use something like this to find and copy emails with a given subject into another mailbox:

Get-Mailbox -ResultSize Unlimited | Search-Mailbox -SearchQuery "Body:’*String*’" -TargetMailbox "FirstName.LastName" -TargetFolder "ZZ_PowerShell_Search"

Open in new window


Change "*String*" by replacing 'String' with all or part of a subject of the email you are wanting to find.

Change the TargetMailBox to wherever you want the emails to go (your own mailbox perhaps), and the TargetFolder to whatever folder you want them to go into.

Be aware that if you have many mailboxes, this might take a while to run, but you can leave it going.



Alan.
0
 
Joseph SalazarVice President - Senior IT ConsultantAuthor Commented:
Thank you Everyone, it appears that $1,000 is the Magic number for a tool to pull the emails and my client does not wish to pay that much.

cjoego
0
 
AlanConsultantCommented:
Hi Jospeh,

Not sure why anyone would pay for functionality that is already built-in to Exchange?

Plus, installing any third-party software on an Exchange Server if a big no-no as far as I am concerned - it is something that can go wrong, and increases the attack surface.

Alan.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.