Improve company productivity with a Business Account.Sign Up

x
?
Solved

Exchange 2007 - Management power shell

Posted on 2014-01-30
2
Medium Priority
?
309 Views
Last Modified: 2014-01-30
Can you tell me what is the cmdlet for this result? See file Picture1

For each maibox display nam contains (DGATI), I want to replace by (DGARI)

What is the cmdlet for execute this?
Picture1.jpg
0
Comment
Question by:dgswin
2 Comments
 
LVL 9

Expert Comment

by:Mahesh Sharma
ID: 39820608
Give a try to this:

1. Export all mailbox with matching condition to csv file.

Get-Mailbox -resultsize unlimited | where-object {$_.CustomAttribute1 -eq "<Value>" -and $_.DisplayName -Match 'DGATI' } | Select Alias, DisplayName | Export-Csv c:\output.csv

2. Not open CSV & replace all DGATI with DGARI
If csv contains " with all reocrds, replace them with null value. Remove first row as well.

3. Import the csv back to mailboxes.

$Temp = Import-Csv c:\output.csv
Foreach ($tmp in $temp) {Get-Mailbox $tmp.Alias | Set-Mailbox -DisplayName $tmp.DisplayName}

Always Try in lab first
0
 
LVL 72

Accepted Solution

by:
Qlemo earned 2000 total points
ID: 39820732
Besides point 2 is probably a typo, that procedure is overcomplicated. PowerShell can do this in one go.
Get-Mailbox -resultsize unlimited |
  where-object {$_.CustomAttribute1 -eq 'D. G. resources humaines et resources informationelles' -and $_.DisplayName -like '*DGATI*' }  |
  % {
    Set-Mailbox $_ -DisplayName $_.Displayname.Replace('DGATI', 'DGARI')
 }

Open in new window

You can add the -whatif to Set-Mailbox to simulate the change only.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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.

Join & Write a Comment

This is a very interesting topic. Ransomware has been around for a while but has increased drastically over the last year or so.
Microsoft has decided to launch the Exchange Server 2019 this year for its on-premise users. What’s new now Microsoft is going to serve its users? How good is it going to be on the current Exchange Server 2016? This blog is going to answer all queri…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…

595 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