How to use Powershell to manage O365 admin center

Question

How to use Powershell to manage O365 admin center

Wu Yuki 81

Hello !
anyone know how to use powershell to manage O365 admin center ?

For example , to add member to share mail box or to change the user's region or location .

thanks for sharing .

Accepted answer

2 additional answers

Your answer

Answer 1

Vasil Michev 119.5K MVP Volunteer Moderator

You can use the Set-MsolUser or Set-AzureADUser cmdlets for that. As for automating this, it's certainly doable, I can provide you with a short example on how to do it as long as you specify which exact property you are looking to modify.

Wu Yuki 81 Reputation points

2021-04-22T01:34:44.617+00:00

Hi Michev ,

thanks , pls provide an example to me.

i will reference your example and do some modify.

thanks for your kindly help
Wu Yuki 81 Reputation points

2021-04-22T01:54:24.67+00:00

Hi Michev,

one questions, is it only work on my role must be Azure Admin ?
Vasil Michev 119.5K Reputation points MVP Volunteer Moderator

2021-04-22T06:36:11.913+00:00
Again, depends on what you are trying to do. User admin role might be sufficient for most cases.

Here's how to update the "country" and "usage location" attributes:

Set-MsolUser -UserPrincipalName ******@domain.com -UsageLocation US -Country USA

If you want to do it in bulk, you can first export the current values to CSV file:

Get-MsolUser -All | select UserPrincipalName,UsageLocation,Country | Export-CSV -nti "blabla.csv"

make the changes in the CSV file, then use it as input:

Import-CSV blabla.csv | % { Set-MsolUser -UserPrincipalName $.UserPrincipalName -UsageLocation $.UsageLocation -Country $_.Country }
Wu Yuki 81 Reputation points

2021-04-22T07:07:27.46+00:00

Hi Michev,

Thanks much!

May I ask how can I filter only country or usage location like" United States" , I try below cmdlet but failed.

Get-MsolUser -All | select UserPrincipalName,UsageLocation,Country | where {$_.Country -eq "United States"}.

If use cmdlet -All ,there are whole data, I don't need all user , I just need to modify some countries.
Vasil Michev 119.5K Reputation points MVP Volunteer Moderator

2021-04-22T09:29:45.683+00:00

Your syntax is correct, but check the actual value as populated for your users. Instead of "United States" it might be something like "USA" or "US".
Wu Yuki 81 Reputation points

2021-04-25T04:07:19.997+00:00

yes , thanks for advice, after try again with below syntax, if has out put now

Get-MsolUser -All | select UserPrincipalName,UsageLocation,Country | where {$_.Country -eq "Hong Kong"} |export-csv "d:\balabla.csv"

again, thank you so much Michev!

Answer 2

Vasil Michev 119.5K MVP Volunteer Moderator

This will depend on which tasks you want to perform. For things such as managing mailboxes or Distribution groups, use the Exchange Online PowerShell module: https://learn.microsoft.com/en-us/powershell/exchange/exchange-online-powershell-v2?view=exchange-ps

For managing user properties, use the MSOnline or AzureAD modules: https://learn.microsoft.com/en-us/powershell/module/azuread/?view=azureadps-2.0

Wu Yuki 81 Reputation points

2021-04-21T10:10:41.483+00:00

HI Michev,

thanks for advice.

yes, I need to manage user properties , after I install the MSonline and AzureAD, how can I change the user profile location by script or by powershell ? what cmdlet can use for this ?

we used to change the location manually in O365 admin center, can we get all the user's location and then modify it correctly by one time?

For example, export it as .CSV and then import correct one like manage Active Directory users and Computers by PowerShell.

Answer 3

Joyce Shen - MSFT 16,701

Hi @Wu Yuki

For example, if you want to add users and license them, you need be a global, license, or a user admin.

In Exchange side, refer to this: Create user mailboxes in Exchange Online

You could use the command like this to perform the action:

New-Mailbox -Alias hollyh -Name hollyh -FirstName Holly -LastName Holt -DisplayName "Holly Holt" -MicrosoftOnlineServicesID ******@corp.contoso.com -Password (ConvertTo-SecureString -String 'P@ssw0rd' -AsPlainText -Force) -ResetPasswordOnNextLogon $true

In addition, we can use Get-ManagementRole -Cmdlet xxx-xxx to get what roles are needed to run the command.

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Wu Yuki 81 Reputation points

2021-04-22T06:27:52.187+00:00

Hi Joyceshen,

thanks for your advice.

but I don't need to create mailbox from Exchange online, what I need is to change a lot of AzureAD user's usage location that make it change the
location on O365 , or said what solution help to change a lot of AzureAD user's location ?

I know the Azure AD usage location which is sync with O365's location , correct ?

thanks a lot for sharing your comment with me in advance .
Joyce Shen - MSFT 16,701 Reputation points

2021-04-28T07:59:21.087+00:00

Hi

Glad to know that your issue is resolved! Some additional information for your reference below:

Configure Microsoft 365 user account properties with PowerShell

And get-azureaduser vs get-msoluser

Hope these will be helpful to you, have a nice day!
Wu Yuki 81 Reputation points

2021-04-29T05:51:29.053+00:00

Hi
thanks for help me a lot

Share via

How to use Powershell to manage O365 admin center

2 additional answers

Your answer