This is the Trace Id: ffc63c8b97d72d434481e62e4376bd7e

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.

Download

  • Version:

    1.0

    Date Published:

    7/15/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.
Back To Top