Import csv get user userprincipalname

Cuongnguyen · 8 Tháng Tư 2021 06:40

https://docs.microsoft.com/answers/questions/60045/export-objectid-of-users-listed-in-csv-file.html
https://red7solutions.co.uk/get-aduser-attributes-from-csv-list-of-users-powershell/
https://community.idera.com/database-tools/powershell/ask_the_experts/f/active_directory__powershell_remoting-9/21193/import-csv-with-displayname-get-samaccountname-output-csv

https://www.manageengine.com/products/ad-manager/powershell/get-aduser-import-csv-module.html

https://notbad.tech/all-things-it/powershell/how-to-bulk-change-the-upn-for-a-list-of-users/

https://blogs.msmvps.com/richardsiddaway/category/powershellandactivedirectory/

gist.github.com

https://gist.github.com/kcchien/300d6218556cc687ce8721eb3190836e

ExportOffice365user.ps1

#import office 365 session
$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session

#connect Azure AD
Connect-MsolService -Credential $UserCredential

#Random password generator
Function random-password ($length = 8)

This file has been truncated. show original

ImportGroupsToAD.ps1

# import csv
$csv = Import-csv C:\Temp\o365GroupData.csv -Encoding UTF8

#connect Azure AD
$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session
Connect-MsolService -Credential $UserCredential

foreach ($item in $csv)

This file has been truncated. show original

ImportUserToAD.ps1

# import Users
import-csv C:\Temp\o365userdata.csv -Encoding UTF8 | foreach-object {New-ADUser -Path ("OU="+$_.Department+",OU=Head Office,DC=kingsteel,DC=com") -Name $_.Name -SamAccountName $_.SAMAccountName -GivenName $_.FirstName -Surname $_.LastName -Department $_.Department -DisplayName $_.DisplayName -EmailAddress $_.EmailAddress -Office $_.Office -ChangePasswordAtLogon $True -Title $_.Title -UserPrincipalName $_.UserPrincipalName -Enable $True -AccountPassword (ConvertTo-SecureString -string $_.Password -AsPlainText -force) }

https://kb.intermedia.net/Article/1712

https://www.adaxes.com/tutorials_ActiveDirectoryManagement_ImportUserAccountsFromCSVFile.htm

http://woshub.com/get-aduser-getting-active-directory-users-data-via-powershell/

https://www.michev.info/Blog/Post/3149/remove-all-office-365-licenses-for-a-group-of-users-from-csv-file-via-the-azure-ad-powershell-module