Utilizing a script to incorporate the userPrincipalName

Question

Utilizing a script to incorporate the userPrincipalName

I'm faced with a situation where I have a CSV file containing all the details of my test script AD users. This includes information like ID number, First Name, Last Name, SamAccountName, and OU Path.

After creating these users, it turns out that some are missing the userPrincipalName attribute while the rest of the attributes are present.

To rectify this issue, I aim to write a script that will add the userPrincipalName to all users.

Here's what I've attempted so far:

$CSVusers = import-csv C:\CorpCSV.csv
$Users = $CSVusers.SamAccountName
$Users | % {Get-ADUser $_ | Set-ADUser $_ -userPrincipalName $Users}

Although the script ran without errors, it seems that nothing changed as the userPrincipalName attribute is still empty in Active Directory (View attached image).

https://i.sstatic.net/oXwic.jpg

typescript powershell active-directory

Answer 1

Answer №1

To determine the desired UserPrincipleName, you must provide specific details.
It appears that this information is not included in your CSV input file.
Typically, the UserPrincipleName follows the format sAMAccountName@DnsDomainName

If all users are from the same domain you are currently logged into, you can generate the domain name using $env:USERDNSDOMAIN or

[System.Net.Dns]::GetHostEntry($env:COMPUTERNAME).HostName

$CSVusers = Import-Csv C:\PollogenCSV.csv
# create an array containing only the sAMAccountNames
$Users = $CSVusers.SamAccountName
$Domain = $env:USERDNSDOMAIN  # alternatively use [System.Net.Dns]::GetHostEntry($env:COMPUTERNAME).HostName
$Users | ForEach-Object { 
    # construct the UserPrincipalName
    $upn = "{0}@{1}" -f $_, $Domain
    Get-ADUser $_ | Set-ADUser -UserPrincipalName $upn
}

Answer 2

To determine the desired UserPrincipleName, you must provide specific details.
It appears that this information is not included in your CSV input file.
Typically, the UserPrincipleName follows the format sAMAccountName@DnsDomainName

If all users are from the same domain you are currently logged into, you can generate the domain name using $env:USERDNSDOMAIN or

[System.Net.Dns]::GetHostEntry($env:COMPUTERNAME).HostName

$CSVusers = Import-Csv C:\PollogenCSV.csv
# create an array containing only the sAMAccountNames
$Users = $CSVusers.SamAccountName
$Domain = $env:USERDNSDOMAIN  # alternatively use [System.Net.Dns]::GetHostEntry($env:COMPUTERNAME).HostName
$Users | ForEach-Object { 
    # construct the UserPrincipalName
    $upn = "{0}@{1}" -f $_, $Domain
    Get-ADUser $_ | Set-ADUser -UserPrincipalName $upn
}

Utilizing a script to incorporate the userPrincipalName

Answer №1

Similar questions

Tips on filtering an array in a JSON response based on certain conditions in Angular 7

Unable to run unit tests on project using my custom React library

Tips for efficiently passing TypeScript constants to Vue templates without triggering excessive reactivity

Developing React components with Typescript requires careful consideration when defining component props, especially when the component may be

verifying the date in a specific moment

Struggling to access my lambda function, an unfamiliar error from AWS/Serverless has presented itself

Can dynamic getters and setters be implemented in TypeScript?

Encountering issues with accessing a variable before its initialization in the getServerSideProps function in

Utilizing the index of a generic type within TypeScript

Typescript struggles to comprehend the nullish-coalescing operator

How can I prevent Intellisense from automatically importing all global variables from Mocha (or any other testing library) into files that are not designated for testing purposes?

Reactjs-ffsevents does not exist as a function

The custom marker created with Leaflet using divIcon does not seem to be styled with the specified

Property ngIf in Angular is not being supplied by any relevant directive within the embedded template

Tips for effectively passing an array to props in Vue when leveraging Typescript and the class component decorator

`Is there a way to assign multiple parameters to HttpParams within Angular 5?`

Mastering the art of typing a member of an abstract generic class in Typescript with consideration for potential additional implementations

Can anyone provide guidance on incorporating lodash into an Ionic 2 project?

Enhancing Visuals with src="imageUrl within Html"

Typescript versus ES5: A comparison of Node.js server-side applications written in different languages