How to Bulk AD users update/modify attributes in AD and Exchange Mailboxes

Question

_{Thursday, November 21, 2019 3:48 PM}

Hi,

How to update/modify the AD-Users(Bulk users) in AD as well as Exchange 2013-2016. It had more than 230 users and attributes needs to change. Kindly suggest.

1.Display name

2.First name

3.Last name

4.Email id

5.Employee ID

6.Contact no.

Thanks-Sami

All replies (6)

_{Friday, November 22, 2019 8:23 AM ✅Answered | 1 vote}

Hi,

If you want to modify mailbox in batch, you should have a source contains the information that you want to modify: 

Then you should to know each attribute contains in which command:

Such as "First name" and "Last name" contains in Get-User, 

So, we can use "Set-User" command to modify them:

$Mailboxes = Import-Csv "c:\temp\infor.csv"

foreach($Mailbox in $Mailboxes){
    Set-User $mailbox.name -FirstName $mailbox.FirstName -LastName $mailbox.lastname
}

Running this script in EMS:

After running this script, we can know this User has been modified:



Regards,

Kyle Xu

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

_{Tuesday, November 26, 2019 8:27 AM ✅Answered}

Hi,

I am writing here to confirm with you how thing going now?

If the above suggestion helps, please be free to mark it as an answer for helping more people.

Regards,

Kyle Xu

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

_{Thursday, November 21, 2019 6:53 PM}

That's why we have PowerShell, and there are thousands of examples available on the internet for this simple scenario. Just look them up.

_{Thursday, November 21, 2019 9:12 PM}

Hi Vasil, I tried all the possibilities to modify the existing users modify the ad attributes. There AD custom attribute 14 in DC side.unable to find and update AD attributes. That’s why I approached forums and they can help and faced similar kind of AD modification in their env.

Thanks-Sami

_{Friday, November 22, 2019 2:56 AM}

You can use CSV method with powershell as below,

https://gallery.technet.microsoft.com/update-active-directory-cd5c5513

https://powershell.org/forums/topic/update-ad-user-from-csv/

Or GUI tool like wise soft Bulk AD tool below,

http://www.wisesoft.co.uk/software/bulkadusers/bulkmodify.aspx

_{Friday, December 27, 2019 2:02 PM}

Hi Kyle,

It's working fine. Thanks a ton.

Thanks-Sami

Thanks-Sami