Change Display name Bulk

Question

Hi I have a csv with the following headings:

Emailaddress, Current Display Name, New Display Name

What I'm trying to do is change the current ad display name to a new one.

Can someone suggest a powershell command that will import the csv file and make the change on AD on prem

I'm guessing it will have to use the emailaddress column since this is the attribute that is unique to identify the user to change.

Thanks

Answer 1

You can follow along here.
https://devblogs.microsoft.com/scripting/use-powershell-to-set-ad-ds-users-display-names/
https://lazyadmin.nl/powershell/using-powershell-to-update-an-ad-user-from-a-csv-file/

--please don't forget to upvote and Accept as answer if the reply is helpful--

Answer 2

Hello @berketjune2012

You can use the next script to update the display names, but needs some tunning depending on your file name and location and the name of colums (text within <>)

$UserCount = 0  
  
Import-Csv -Path <C:\MyADUsers.csv> | ForEach-Object {  
  
$UPN = $_.<Name>  
Write-Host “Working on user:” $UPN  
Get-ADUser -Filter {Name -Eq $UPN} | Set-AdUser -Name $_.EmailAddress  
$usercount = $usercount +1  
}  
Write-Host “Total users on your CSV: $UserCount”  
Write-Host “UPN’s Changed”  
  
or in a more simplified way, with "Email" column name and "DisplayName" column:  
  
Import-Csv 1.csv | Foreach {Get-User -Identity $_.email | Set-User -DisplayName $_.DisplayName}  

Best regards,