Update UPN with SAMAccountname

spiceuser-vzcws · 2019-04-26T13:15:04.000Z

I need a script that will read the SAMAccountname from a CSV and update the UPN in each user account with the SAMAccountname.

This works for an individual account, but I need it to pull from a csv and place the user in the ‘userid’.

Get-ADUser ‘userid’ |
ForEach-Object{
$upn = $.UserPrincipalName -replace ‘.*@’, ($.SamAccountName + ‘@’)
$_ | Set-ADUser -UserPrincipalName $upn
}

DoctorDNS · 2019-04-26T13:18:45.000Z

Have you tried it?

Neally · 2019-04-26T13:19:50.000Z

Welcome

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Neally · 2019-04-26T13:21:10.000Z

Well, if the snippet you have works, you just need to expand the ‘get-aduser’ from a single user, to all users.

Get-ADUser 'userid'

#to

Get-ADUser -Filter *

You want to thoroughly test this before letting it loose on your entire AD.

spiceuser-vzcws · 2019-04-26T13:22:32.000Z

Yes this script works but I would have to enter each userid/samaccountname (get-aduser ‘samaccountname’) for each users.

I have a CSV that I want to pull the user from. It has one value - the samaccountname and I want it to replace the UPN prefix with the samaccountname. I am not a programmer and learn as I go. Here are some things I have tried.

$Users = Import-Csv -path C:\temp\InputTest1.csv

Get-ADUser $Users |
ForEach-Object{
$upn = $.UserPrincipalName -replace ‘.*@’, ($.SamAccountName + ‘@’)
$_ | Set-ADUser -UserPrincipalName $upn
}

or

$Users = Import-Csv -path C:\temp\InputTest1.csv

Foreach($User in $Users) {

Get-aduser -identity $User | Set-ADUser -UserPrincipalName $User

}

or

$Users = Import-Csv -path C:\temp\InputTest1.csv

Get-ADUser $Users |
ForEach-Object{
$upn = $.UserPrincipalName -replace ‘.*@’, ($.SamAccountName + ‘@’)
$_ | Set-ADUser -UserPrincipalName $upn
}

Neally · 2019-04-26T13:24:39.000Z

ErikSanchez:

I need a script that will read the SAMAccountname from a CSV and update the UPN in each user account with the SAMAccountname.

Here are some things I have tried.

Some of them seem promising, what were the issues you run into?

spiceuser-vzcws · 2019-04-26T13:25:51.000Z

Will do - Thank you for the info!

spiceuser-vzcws · 2019-04-26T13:27:18.000Z

The main issue was on the Get-ADUser – Cannot validate argument on parameter ‘Identity’. The argument is null…

This seems to me like it is not reading the CSV…

Neally · 2019-04-26T13:35:05.000Z

ErikSanchez:

The main issue was on the Get-ADUser – Cannot validate argument on parameter ‘Identity’. The argument is null…

This seems to me like it is not reading the CSV…

Does your CSV have headers?

e.g.

UserNameList
username01
username02
username03

$csv = import-csv "c:\file.csv"

foreach($line in $csv){
Get-ADUser $line.UserNameList |
  ForEach-Object{
    $upn = $_.UserPrincipalName -replace '.*@', ($_.SamAccountName + '@')
    $_ | Set-ADUser $line.UserNameList -UserPrincipalName $upn
  }
}

spiceuser-vzcws · 2019-04-26T13:47:30.000Z

That is getting closer, but still an error:

Set-ADUser : The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input
and its properties do not match any of the parameters that take pipeline input.
At line:7 char:10

$_ | Set-ADUser $line.UserNameList -UserPrincipalName $upn
CategoryInfo : InvalidArgument: (CN=USER…=DOMAIN,DC=local:PSObject) [Set-ADUser], ParameterBindingException
FullyQualifiedErrorId : InputObjectNotBound,Microsoft.ActiveDirectory.Management.Commands.SetADUser

Neally · 2019-04-26T13:48:12.000Z

ErikSanchez:

That is getting closer, but still an error:

Set-ADUser : The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input
and its properties do not match any of the parameters that take pipeline input.
At line:7 char:10
$_ | Set-ADUser $line.UserNameList -UserPrincipalName $upn
CategoryInfo : InvalidArgument: (CN=USER…=DOMAIN,DC=local:PSObject) [Set-ADUser], ParameterBindingException

FullyQualifiedErrorId : InputObjectNotBound,Microsoft.ActiveDirectory.Management.Commands.SetADUser

can you post your code? What I posted still needs to be updated, that will not work just like that. Look at the $upn part, you see a ‘$_’ there, that needs to be changed to $line and so forth.

spiceuser-vzcws · 2019-04-26T13:58:31.000Z

$csv = import-csv "C:\temp\InputTest.csv"

foreach($line in $csv){
Get-ADUser $line.UserNameList |
  ForEach-Object{
    $upn = $_.UserPrincipalName -replace '.*@', ($_.SamAccountName + '@')
    $_ | Set-ADUser $line.UserNameList -UserPrincipalName $upn
  }
}

Within the CSV I added the header UserNameList…

After I got the error I changed the code to just the following and it listed each test account I had in the CSV file. So the import works.

$csv = import-csv "C:\temp\InputTest.csv"

foreach($line in $csv){
Get-ADUser $line.UserNameList}

Neally · 2019-04-26T14:03:07.000Z

ok, cool, that was just an example though as we don’t know what your actual CSV looks like…

Do you have more than one column in it?

$csv = import-csv "C:\temp\InputTest.csv"

foreach($line in $csv){
Get-ADUser $line.UserNameList |
  ForEach-Object{
    $upn = $_.UserPrincipalName -replace '.*@', ($_.SamAccountName + '@')
    $_ | Set-ADUser $line.UserNameList -UserPrincipalName $upn
  }
}

needs to be updated to refext the foreach, rather than a foreach-object

$csv = import-csv "C:\temp\InputTest.csv"

foreach($line in $csv){
Get-ADUser $line.UserNameList |
  ForEach-Object{
    $upn = $line.UserPrincipalName -replace '.*@', ($line.SamAccountName + '@')
    Set-ADUser $line.UserNameList -UserPrincipalName $upn
  }
}

more like so.

again, i can not test that as I don’t know what your CSV looks like.

spiceuser-vzcws · 2019-04-26T14:14:42.000Z

That didn’t work either…

Here is what is in my csv

UserNameList eriktest etest2 eriktest3 RQITest

jitensh · 2019-04-26T14:22:56.000Z

if I understand you want to match samaccountname as userprinipal name,

$csv = import-csv "c:\file.csv"
foreach($line in $csv){
   $upn='@domain.com'
 Set-ADUser $line.UserNameList  -UserPrincipalName {$_.$line.UserNameList + $upn }
  
}

^ change domain.com to real user principal name

spiceuser-vzcws · 2019-04-26T14:45:06.000Z

To clarify… Some of our users have for their UPN: fLast@Domain.local and SAM as: Domain\ #######. What I want to do is read from a CSV that has the SAMAccountName to identify the correct users and copy the SAMAccountname and place it in the Prefix of the UPN. I do not want to mess with anything after the @…

New UPN would be ######@domain.local to match the SAMAccountname…

Neally · 2019-04-26T15:48:13.000Z

like so?

foreach($line in $csv){
    $upn = ((get-aduser $line.usernamelist).userprincipalname -split "@")[1]
    set-aduser $line.usernamelist -UserPrincipalName "$($line.usernamelist)@$upn"
}

cweb · 2019-04-26T17:39:28.000Z

ErikSanchez:

To clarify… Some of our users have for their UPN: fLast@Domain.local and SAM as: Domain\ #######. What I want to do is read from a CSV that has the SAMAccountName to identify the correct users and copy the SAMAccountname and place it in the Prefix of the UPN. I do not want to mess with anything after the @…

New UPN would be ######@domain.local to match the SAMAccountname…

No real need to use a CSV and mess with the CSV at all really… The CSV might be complicating it, you could query the AD with a simple filter and Get-aduser for Samaccount Not like Userprincipalname and then pass it to a Foreach Loop to Set Userprincipalname like Samaccount.

I’ve found when dealing with UPN’s that if you change it via powershell and don’t specify an @domain.local then it blanks out that field.