Updating Employee Hire Date with PowerShell.

Question

Is the a script a can use to update EmployeeHireDate with PowerShell while referencing a csv list for the list of employees?

Answer 1

Hi @Stefan Diedericks ,

this should be possible using the Update-AzADUser cmdlet of the AzureAD PowerShell module.

Read the content of the CSV file first (UPN or ObjectID is required) and use a foreach loop for every line in the CSV file.

A sample could look like this (not tested!):

$csvFile = "users.csv" # assuming there is a column named UPN
$hireDate = (Get-Date).Date # Get date of today
Import-Csv -Path $csvFile | ForEach-Object {
    Update-AzADUser -UPNOrObjectId $_.UPN -EmployeeHireDate $hireDate
}

---

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards

Andreas Baumgarten