?
Solved

Need Exchange 2010 tool to do selective purge

Posted on 2013-06-26
4
Medium Priority
?
365 Views
Last Modified: 2013-06-26
Hello,

I have been tasked to find some kind of script or program that can do the following.

1. Reach into all existing Exchange accounts
2. Read each email between a certain date range
3. Apply a conditions based filter and delete each email that finds a match.

For example, if an email has a certain email address in the to, from, subject, or body of an email, delete it.  If not, check the next condition, etc...  I have a list of such conditions that need to be searched for, so the ability to nest AND/OR statements it a must.

Can anyone recommend any software or script that can do this?

TIA
0
Comment
Question by:TakedaT
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:Raj-GT
ID: 39277970
You can use the search-mailbox powershell cmdlet for this. See http://technet.microsoft.com/en-us/library/dd298173%28v=exchg.141%29.aspx

You can search across all mailboxes in your Exchange Organization and delete/move mails matching your criteria to a target mailbox.
0
 
LVL 10

Author Comment

by:TakedaT
ID: 39279423
Thanks, Raj-GT.  This looks really powerful, but also really dangerous if a typo is made.  Could you also point me to some help on setting up a complex query?  I looked around all I can find is rather simple queries.  Or if you can lend a hand yourself.

For example, I have a list of domain names that I need to find in all parts of an email, To:, From: Subject: Body. and delete any found.

Then I have a list of keywords to find matches on.  For example, if an email has the word 'firstword' but also has 'secondword' in it.  Then 'firstword' and 'thirdword'.  and delete these if found.

So a brief summary would be:
Match all emails where To: OR From: OR Subject: OR Body: contains any of the following
  domain1.com
  domain2.net
  domain3.org
-end of first condition
Match any email with 'firstword' AND at least one of the following:
  secondword
  thirdword
  fourthword
  etc..
-end of second condition

I would like to do this in one pass if possible.  the way it looks is I may need to do 25 or so passes as my list of words is at about 20.
0
 
LVL 15

Accepted Solution

by:
Raj-GT earned 2000 total points
ID: 39279507
The searchstring could simply be "domain1.com OR domain2.net OR domain3.org AND secondword OR thirdword OR fourthword". You can test your search query using the multi mailbox search feature in exchange 2010. This will not allow you to delete the messages but just copy them to a target mailbox. See link below for instructions...

http://demazter.wordpress.com/2010/04/29/multi-mailbox-search-with-exchange-2010/
0
 
LVL 10

Author Closing Comment

by:TakedaT
ID: 39280054
OK, you got me in the right direction.  It looks like it takes nested statements inside parenthesis like a normal math equation.  So doing "domain1.com OR domain2.net OR (firstword AND secondword) OR (firstword AND thirdword) OR etc..." does what I need.

Thanks for the help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Suggested Courses
Course of the Month14 days, 19 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question