Forum Discussion
Exchange Online - Mailbox Regional Setting Configuration
Hello, I need to change the default regional setting for all user mailboxes in EXO. What I've tried to do is pull out all current mailbox settings using this command:
Get-Mailbox -ResultSize unlimited | Get-MailboxRegionalConfiguration | Export-csv -Path c:\regionalsettings.csv
The problem is that the command eventually times out because I have too many mailboxes. I opened a ticket with MS, and they gave me some suggestions but wouldn't actually give me the working command. Here's what they said:
There are a couple of solutions or workarounds.
- One solution could be to split the command and run it against each database instead and then combine the result.
- Another option is to use a For Each loop instead of piping the command, this seems to work in most cases as well.
I'm not that good with PowerShell so I'm looking for some help. I've tried to just run the command to change everything to Eastern Standard Time, but I have the same issue with the timeouts:
Get-Mailbox -ResultSize Unlimited | Select-Object WindowsEmailAddress |Export-CSV c:\WindowsEmailAddress.csv
Import-Csv c:\WindowsEmailAddress.csv | foreach {Set-MailboxRegionalConfiguration -Identity $_.WindowsEmailAddress -TimeZone “Eastern Standard Time”};{Start-Sleep -Milliseconds 500}
Maybe also other experts can give a suggestion, but from my side, I will run this in a patch,
so as I have all the CSV, (I don't know how many mailboxes before timeout), but will go through 200 mailboxes, update the settings than another 200 Mailbox, and so on.
Is this good.
I've had a client run on this same problem - we resolved by using the new Exchange Powershell v2 module https://docs.microsoft.com/en-gb/powershell/exchange/exchange-online-powershell-v2?view=exchange-ps
When we ran
Get-ExoMailbox -ResultSize unlimited | Get-MailboxRegionalConfigurationIt was much faster and didn't time out - although they may have far fewer mailboxes than your tenant. Might be worth a quick try. If not I'm sure one of the Powershell Guru's will be able to help with the Powershell code
- Am I correct in the sense, that there is still no way to set a default Mailboxregionalsetting to be used for newly created mailboxes?
Issue is users are only connecting to mailboxes using Outlook, and foldernames are always in English in stead of local language...so we need to run this every time a new user is created?
