Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1420
  • Last Modified:

Query Exchange Database

We have the need to query our entire Exchange database for certain terms that might appear in an email body, and for certain external recipient email addresses.  Is there a way to do this?  From what I can see, we can only query specific mailboxes for this information - not the entire database.
0
southpau1
Asked:
southpau1
  • 3
  • 2
2 Solutions
 
tigermattCommented:
You didn't mention the version of Exchange you are using.

If Exchange 2010, then multi-mailbox search is your friend. This has the option to search all the mailboxes in the organisation, or just a subset thereof. See http://technet.microsoft.com/en-us/library/dd335072.aspx for details.

Such features are not easily built-in to older versions of Exchange. Exchange 2007 has this functionality in the Exchange Management Shell, using a combination of the Get-Mailbox -Database <your mailbox database> and piping the results of this cmdlet to Export-Mailbox, which can extract specific detail from all the mailboxes returned from the first search. This is by no means efficient or easy, though.

In Exchange 2003, you would be looking at a scripted approach or a third-party tool. The Exmerge tool with 2003 unfortunately does not allow you to scan the body of messages for particular keywords; only the subject lines.

-Matt
0
 
southpau1Author Commented:
Thanks.  Not sure of my Exchange version.  I am asking this question on behalf of another admin.  Thanks for being thorough though.  I'll get back to you soon.
0
 
southpau1Author Commented:
Ok we have Exchange 2003, so I guess it will be difficult to search the message body.

What about scanning the entire database for specific To: and From: addresses of external email addresses?  Looking at Exmerge here too?
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
tigermattCommented:
OK, exmerge isn't going to work in that case, as it does not have filtering capabilities by Sender or Recipient either.

You're going to be looking at third-party utilities to achieve this satisfactorily. Apparently, Ontrack Powercontrols has the ability to do this (see http://www.krollontrack.com/information-management/email-management-for-exchange/email-search/). That software is held in high acclaim, but I do have to say I've never found a need to use it personally, so I can't recommend it any more than suggest you take a look and play for yourself!

-Matt
0
 
Nagendra Pratap SinghCommented:
Do  want to remove certain offensive/sensitive emails?
0
 
southpau1Author Commented:
i don't want to remove anything..i want to find all emails with a few specific search terms.
0

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now