How to set the usage location for MS 365 users that is based on their country information in Active Directory

Summary: This article contains step-by-step instructions on how to set the usage location for MS 365 users that is based on their country information in Active Directory.

Two scenarios are possible:

1. Update usage location for existent Microsoft 365 users

2. Set usage location for nearly created Microsoft 365 users

Applies to: Cayosoft Administrator 8.x and later

Configuration

Update usage location for existent Microsoft 365 users

1. In the Cayosoft Administrator Console, create the AD Users rule.

2. Change the rule Output type to Export to CSV Text file.

3. Add the Country attribute to Properties to display.

4. Check that UserPricipalName is also in the Properties to display list.

5. Configure Query criteria if needed.

6. Save changes and run the rule.

7. Create the Text file | Update Office 365 Users rule.

8. Select exported CSV file from AD Users rule as a data source.

9. Use the UserPrincipalName as an anchor attribute.

10. In the Settings > Usage Location select Country column from the CSV file.

11. Save changes and run the rule.

Set usage location for nearly created Microsoft 365 users

To have a country name from Active Directory in the office location for Microsoft 365 users you should use {$_.Country} in the AD Users | Create Office 365 Accounts (Cloud) rule in your runbook for new users provision: