Solved

get-mailbox delete content in specific OU or distribution list

Posted on 2013-10-28
13
1,519 Views
Last Modified: 2013-10-31
hello, i am trying to delete content from multiple users mailbox.

The command i am using does so successfully for one user, however i am looking to target a specific user base and particular subject either inside an OU or inside a distribution list. So far the script i am using doesnt work. Can anyone help?

Get-Mailbox -OrganizationalUnit "ou=local" –ResultSize unlimited | Search-Mailbox -SearchQuery 'subject:*subject*' –DeleteContent
 

(assume the OU path is accurate)

thanks in advance
0
Comment
Question by:mrbayIt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 5

Expert Comment

by:Recept
ID: 39607578
When specifying the OU use the full path including domain name.

For example;
Get-Mailbox -OrganizationalUnit 'domain.com/OU' –ResultSize unlimited | Search-Mailbox -SearchQuery 'subject:*subject*' –DeleteContent


If this still doesn't work please post the error message.
0
 

Author Comment

by:mrbayIt
ID: 39607633
thank you i tried the full path before and it didnt work, by full path do you mean

ou=etc,ou=etc,dc=domain,dc=local
0
 
LVL 5

Expert Comment

by:Recept
ID: 39607785
That is correct, either should work

Get-Mailbox -OrganizationalUnit 'domain.local/etc/etc' –ResultSize unlimited | Search-Mailbox -SearchQuery 'subject:*subject*' –DeleteContent

Get-Mailbox -OrganizationalUnit 'ou=etc,ou=etc,dc=domain,dc=local' –ResultSize unlimited | Search-Mailbox -SearchQuery 'subject:*subject*' –DeleteContent


I'd suggest you run just the Get-Mailbox command first to make sure it is working, once confirmed you can add the Search-Mailbox.

Get-Mailbox -OrganizationalUnit 'domain.local/etc/etc' –ResultSize unlimited

OR

Get-Mailbox -OrganizationalUnit 'ou=etc,ou=etc,dc=domain,dc=local' –ResultSize unlimited
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:mrbayIt
ID: 39607787
it looked like it was going to work then got an

"unexpected error a watson event has been generated"

Object reference not set to an instance of an object
0
 
LVL 5

Expert Comment

by:Recept
ID: 39607850
That sounds like an error outside of Exchange Management Shell. Did you receive it running just the Get-Mailbox command or the full thing?

Perhaps try with a smaller -ResultSize as a test.

Get-Mailbox -OrganizationalUnit 'domain.local/etc/etc' –ResultSize 10
0
 

Author Comment

by:mrbayIt
ID: 39607856
interesting i cant go above 30, but the number of people in the OU is 50 so i need to process more than that. Any idea why?
0
 
LVL 5

Expert Comment

by:Recept
ID: 39610365
It's not clear why the Exchange Management Shell is crashing, it certainly should be able to handle many more than 30 results. Do you have another machine with the Exchange Management Shell installed?

To workaround the issue you could filter the results based on name so you're dealing with smaller number of users.

Get-Mailbox -OrganizationalUnit 'domain.local/etc/etc' –ResultSize Unlimited -Filter {(name -gt 'a') -and (name -lt 'f')}

Get-Mailbox -OrganizationalUnit 'domain.local/etc/etc' –ResultSize Unlimited -Filter {(name -gt 'g') -and (name -lt 'r')}

Get-Mailbox -OrganizationalUnit 'domain.local/etc/etc' –ResultSize Unlimited -Filter {(name -gt 's') -and (name -lt 'z')}

Open in new window


If that works then try and add the second part of the command back into the mix.

Get-Mailbox -OrganizationalUnit 'domain.local/etc/etc' –ResultSize Unlimited -Filter {(name -gt 'a') -and (name -lt 'f')} | Search-Mailbox -SearchQuery 'subject:*subject*' –DeleteContent

Get-Mailbox -OrganizationalUnit 'domain.local/etc/etc' –ResultSize Unlimited -Filter {(name -gt 'g') -and (name -lt 'r')} | Search-Mailbox -SearchQuery 'subject:*subject*' –DeleteContent

Get-Mailbox -OrganizationalUnit 'domain.local/etc/etc' –ResultSize Unlimited -Filter {(name -gt 's') -and (name -lt 'z')} | Search-Mailbox -SearchQuery 'subject:*subject*' –DeleteContent

Open in new window

0
 

Author Comment

by:mrbayIt
ID: 39610475
i like that approach alot, however tried it and got

the command got positional parameter cannot be found that accepts argument filter
0
 

Author Comment

by:mrbayIt
ID: 39610492
oh you know what im sorry it did work, i tried to apply it on a different filter. Instead of OU's im doing distriibution list which gave me a better view of what i was looking for. I assumed i could apply the same path to that parameter but i guess i cant. Here is the string i am trying now

Get-Distributiongroupmember alias –ResultSize unlimited -Filter {(name -gt 'a') -and (name -lt 'f')} | Search-Mailbox -SearchQuery 'subject:subject' –DeleteContent
0
 
LVL 5

Expert Comment

by:Recept
ID: 39610518
Does the Get-DistributionGroupMember return all of the users or bomb out at 30 results as well?

Get-Distributiongroupmember alias –ResultSize unlimited
0
 

Author Comment

by:mrbayIt
ID: 39610540
it bombs out just l like the other one, and only works at 40. However your idea for doing it by name group is perfect only problem is the error i mentioned above that i get, parameter one
i should note im on exchange 2010 with latest sp and rolup
0
 
LVL 5

Accepted Solution

by:
Recept earned 500 total points
ID: 39610609
I fear it will bomb out but can you try;

Get-Distributiongroupmember alias –ResultSize unlimited | Select-Object -First 30

Get-Distributiongroupmember alias –ResultSize unlimited | Select-Object -Last 20

Open in new window


Does this give you the 50 members your after?
0
 

Author Closing Comment

by:mrbayIt
ID: 39613733
thank you so much
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
Unified and professional email signatures help maintain a consistent company brand image to the outside world. This article shows how to create an email signature in Exchange Server 2010 using a transport rule and how to overcome native limitations …
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

752 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