Bulk update AAD office locations

Use this utility to update the PhysicalDeliveryOfficeName field in AAD profiles using a CSV file

Important! Selecting a language below will dynamically change the complete page content to that language.

Select language

Version:
1.0
Date Published:
15/07/2024
File Name:
BulkUpdateOfficeLocations.ps1
File Size:
1.7 KB
This PowerShell utility updates the PhysicalDeliveryOfficeName (or Office) field in AAD profiles using a CSV file. The CSV file should contain a mapping between AAD aliases and the office info. It also backs up existing data to ensure that the changes can be rolled back.
Supported Operating Systems
Windows 10, Windows Server 2016
- Requires Windows 10 or Windows Server 2016
1. Click Download to download the utility.
2. Create a CSV file. For example, create a file named 'LocationInfo.csv'.
3. Add rows containing user alias and office location info to the CSV file. For example, AdeleV@contoso.com,2/1173. Ensure you have a separate row for each alias, office location) pair.
4. Open Windows PowerShell.
5. From commandline, cd to the folder containing the script.
6. Run BulkUpdateOfficeLocations.ps1.
7. Login using AAD credentials.
8. Provide path of CSV file.
9. The script will try to update the office field for the AAD aliases in the CSV file and publish a summary.