Bulk update Azure AD with user attributes from CSV

I am looking for a way to update user attributes (OfficePhone and Department) for about 500 users from a CSV to AzureAD using a powershell. Does anyone know of a script that I could use? I am new her...

Azure Active Directory

office 365

Manfred101

May 08, 2020

jebujohn

Hello Jacob,

Your CSV has to look something like this:

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

Your Powershell code:

# Connect to AzureAD
Connect-AzureAD

# Get CSV content
$CSVrecords = Import-Csv C:\Temp\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 -Department $CSVrecord.Department -TelephoneNumber $CSVrecord.TelephoneNumber
        } 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

Good luck!

Kind Regards, Manfred de Laat

vipfafen
Copper Contributor
Aug 18, 2021
Finaly it Woks! Thank you jebujohn
jebujohn
Copper Contributor
Aug 18, 2021
Try a csv with UserPrincipalName, Manager where both are UPNs. The UserPrincipalName for the user whom you want to assign a manager and under the manager the UPN of the manager
vipfafen
Copper Contributor
Aug 18, 2021
Thanks for the quick response, but I run into mistakes. My CSV is structured as follows:

UserPrincipalName,"ManagerName"
<Username.username>#EXT#@<domain>,"<Managername>, <Managersurname>"
<username.username>@<domain2>,"<Managername>, <Managersurname>"
...

jebujohn

Copper Contributor

Aug 18, 2021

vipfafen

$CSVrecords = Import-Csv test.csv -Delimiter ","
foreach ($CSVrecord in $CSVrecords) {
$usr = $CSVrecord.UserPrincipalName
$manager = $CSVrecord.Manager
$user = Get-AzureADUser -Filter "userPrincipalName eq '$usr'"
$Managerobj = Get-AzureADUser -Filter "userprincipalname eq '$manager'"
if ($user) {
 try{
 $user | Set-AzureADUserManager -RefObjectid $Managerobj.objectid
} catch {
   $FailedUsers += $usr
Write-Warning "$usr user found, but FAILED to update."
  }
 }
  else {
   Write-Warning "$usr not found, skipped"
$SkippedUsers += $usr
  }
 }

vipfafen
Copper Contributor
Aug 18, 2021
@arnelianfox did you get a working script? Can't get it to work either
carnelianfox
Copper Contributor
Mar 02, 2021
Jacob John could you please write out the script in full. It's a bit confusing the way you put it. I am unable to correctly update User Manager. Thanks,
Jacob John
Copper Contributor
Nov 28, 2020
sunJeezy
The appropriate command is set-azureadusermanager
you will need the azureAD objectid of the manager, which we will have to first call. So this script will not work as is.
$user=$CSVrecord.UserPrinicipalName
$Manager= $CSVrecord.Manager
$ManagerObj=Get-AzureADUser -Objectid $Manager
Set-AzureADUserManager -ObjectId $User -RefObjectId $ManagerObj.ObjectId

In your specific instance, it may be simple to populate the csv with the objectid of the single manager or the script with the objectid as only one manager exists.
sunJeezy
Copper Contributor
Nov 27, 2020
There are no spaces in the CSV. I've modified the script a bunch of times in order to update all the fields for my 1500 users, which worked flawlessly. The manager piece is what I am having a challenge with.

I already have the AzureAD module installed. I've already updated all the other fields with no issues.

Going back to the documentation for Set-AzureADUser (https://docs.microsoft.com/en-us/powershell/module/azuread/set-azureaduser?view=azureadps-2.0) I do not see "Manager" listed as a parameter.
jpcaid
Copper Contributor
Nov 27, 2020
sunJeezy copy my script posted above and edit it to suit you.
also make sure there is no spaces in your CSV file
RhysButler
Copper Contributor
Nov 27, 2020
sunJeezyYou need to install the AzureModule (install-module azuread)
sunJeezy
Copper Contributor
Nov 27, 2020
The Azure_manager.csv file contains userprincipalname;manager

# Connect to AzureAD
Connect-AzureAD

# Get CSV content
$CSVrecords = Import-Csv C:\Users\k4rna\Desktop\azureinfocorrection\azure_manager.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 -Manager $CSVrecord.Manager
        } 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
jpcaid
Copper Contributor
Nov 27, 2020
sunJeezy lets see the whole script
sunJeezy
Copper Contributor
Nov 27, 2020
I just tried loading up powershell and typing,

Connect-AzureAD
Get-ADUser

Received the following error:

Get-ADUser : The term 'Get-ADUser' is not recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1
+ Get-ADUser
+ ~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (Get-ADUser:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
jpcaid
Copper Contributor
Nov 27, 2020
yea i did this on azure ad

Forum Discussion

Bulk update Azure AD with user attributes from CSV

Share

Resources