Clash Royale CLAN TAG

How to edit only the Firstname (givenName) of multiple users and import with csv

If I have a list of users where the samAccountName for all the users are all numerical Example, 745744, 745746, etc…. I was looking for a powershell script that could accomplish the following:

Is having only one column in excel with the samAccountName sufficient for the csv, or do i need to also have all of the users givenName as well inside of the csv?? Example column A samAccountName, column B Firstname??

Example givenName is, JOAQUIN, I would need the first name to be XXJOAQUIN. I have about 500 users that I would have to do this for, and we are doing it manually right now, So the only thing that I need changed is adding the “XX” before the users givenNames….

Thanks everyone in advance.

3 Answers
3

If your CSV file just contains a header with the samAccountName followed by the samAccountNames like this:

samAccountName

samAccountName
745744
745746

Then you can use the following piece of code, change the path to the path of the csv file with your users.
This could be made shorter and use the pipeline better to make it less code, but this will work just fine.

$users = Import-Csv -Path .users.csv

foreach($user in $users) {
$obj = Get-ADUser -Identity $user.samAccountName
Set-ADUser -Identity $user.samAccountName -GivenName ("xx" + $obj.GivenName)
}


If you have a CSV with samAccountName as the first column, you can do something like this.

$Users = Import-CSV "Users.csv"
Foreach($User in $Users){

$ADUser = Get-ADUser $User.samAccountName

$ADUser.GivenName = "XX$($ADUser.GivenName)"

Set-ADUser -Instance $ADUser
}


If you are searching for numerical users, you can look up in the documentation to use Get-ADUser to get all your users, and use a foreach loop to evaluate if it is numerical, and set the account.

Get-ADUser

foreach

$Users |

Foreach-Object

foreach

You can also pipe the output directly from Get-ADUser to Set-ADUser like this:

Get-ADUser

Set-ADUser

$users = Import-Csv -Path .users.csv
foreach($user in $users) {
Get-ADUser -Identity $user.SamAccountName | % {Set-ADUser -Identity $_.SamAccountName -GivenName ("xx" + $_.GivenName)}
}


But since you are reffering to the same element twice, I don't see a reason why you shouldn't do it directly like this:

$users = Import-Csv -Path .users.csv
foreach($user in $users) {
Set-ADUser -Identity $user.SamAccountName -GivenName ("xx" + $_.GivenName)
}


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.