How to update immutableID for all user in Azure AD

Question

Hi,

I have a CSV file that contains ImmutableID and UPN with the following headers for all user to be sync to Azure AD:

UserPrincipalName
ImmutableID

How can I set all user to use the CSV to update into the cloud?

Answer 1

Can you tell us what exactly are you trying to achieve here? Are you attempting to use the "hard match" method or something else entirely?

Answer 2

Hello @eddy sophian

Thank you very much for reaching out to us in regards to your concern you can use the following script mention in the below article to bulk update the user Immutable ID also please confirm if your end goal is to hard match the users as said by @Vasil Michev .

Your CSV has to look something like this:

UserPrincipalName;Department;TelephoneNumber
manfreddelaat@keyman .nl;IT;0135113333
manfred@keyman .nl;IT;0622222222

Your Powershell code:

Connect to AzureAD
Connect-AzureAD

Get CSV content
$CSVrecords = Import-Csv C:\Test.csv -Delimiter ";"

Create arrays for skipped and failed users
$SkippedUsers = @()
$FailedUsers = @()

Loop trough CSV records
foreach ($CSVrecord in $CSVrecords) {
$upn = $CSVrecord.UserPrincipalName
$user = Get-AzureADUser -Filter "userPrincipalName eq '$upn'"
if ($user) {
try{
$user | Set-AzureADUser -ImmutableId $CSVrecord.ImmutableId
} catch {
$FailedUsers += $upn
Write-Warning "$upn user found, but FAILED to update."
}
}
else {
Write-Warning "$upn not found, skipped"
$SkippedUsers += $upn
}
}

Array skipped users
$SkippedUsers

Array failed users
$FailedUsers

https://techcommunity.microsoft.com/t5/windows-powershell/bulk-update-azure-ad-with-user-attributes-from-csv/m-p/1374479

In case you have any questions on the same, you can surely let us know and we will be happy to help you further. If this post provides you the answer you were looking for, do accept it as an answer in the interest of community members with similar queries. If this does not answer, please ask further in the comments and we will happy to address your concerns. Thank you.