Managing Mailbox Time Zone and Language setting by using PowerShell | Office 3654 min read
By default, when a user opens the OWA (Outlook web apps) web interface for the first time, special windows will be displayed, asking the user to select the values for Time Zone and Language.
As an Exchange Online administrator, Many time we would like to set a predefined setting for this values (Time Zone and Language) for making the user life easier and avoiding users mistakes.
In this article, we will learn how to manage the Time Zone and Language setting for a: particular Mailbox and, by using a Bulk operation that will set values for a Multiple Mailboxes.
Article Table of content | Click to Expand
PowerShell | Help & additional information
In case that you are a novice in the PowerShell environment, you can use the following link to get more information about the “first steps” such as: downloading the required PowerShell
software components, how to use the PowerShell console, running a PowerShell script, etc.
| Link Table |
| PowerShell Naming Conventions & general information
If you want to get more information about the Naming Conventions that we use for this article and get some general tips about: how to work with the PowerShell, read the article: Help and additional information – o365info.com PowerShell articles |
| Create remote PowerShell session
Before we can use the required PowerShell commands, we need to download and install the Office 365 cmdlets + create remote PowerShell session to Office 365 or Exchange Online. If you need more information about how to create a remote PowerShell session read the following articles: Part 2: Connect to Office 365 by using Remote PowerShell and Part 3: Connect to Exchange Online by using Remote PowerShell |
| How to use a PowerShell script
Most of the PowerShell articles include a PowerShell script that simplifies the use of the PowerShell commands. If you want to get more information about: How to use a PowerShell script, read the article: Connect to Office 365 and Exchange Online using a script |
| PowerShell command and Script languish in more details
If you are new to the PowerShell world, you can read more information about PowerShell in Office 365 environment in the article: The Power of PowerShell |
1. Set Time Zone and Language: Mailbox settings
1.1 – Set Time Zone for a Mailbox
PowerShell command Syntax
|
1 |
Set-MailboxRegionalConfiguration <Identity> -TimeZone <"Time Zone"> |
PowerShell command Example
|
1 |
Set-MailboxRegionalConfiguration John -TimeZone "Pacific Standard Time" |
1.2 – Set Time Zone + Language for a Mailbox
PowerShell command Syntax
|
1 |
set-MailboxRegionalConfiguration <Identity> -TimeZone <"Time Zone"> –Language <Language Code> |
PowerShell command Example
|
1 |
Set-MailboxRegionalConfiguration John -TimeZone "Pacific Standard Time" –Language en-US |
1.3 – Set Time Zone + Language + Date/Time Format for a Mailbox
PowerShell command Syntax
|
1 |
Set-MailboxRegionalConfiguration <Identity> -TimeZone <"Time Zone"> –Language -DateFormat <"Date Format"> –TimeFormat <"Time Format"> |
PowerShell command Example
|
1 |
Set-MailboxRegionalConfiguration <Identity> -TimeZone "Pacific Standard Time" –Language en-US -DateFormat "dd/MM/yyyy" -TimeFormat "h:mm tt" |
2. Set Time Zone and Language (Bulk Mode)
2.1 – Set Time zone on ALL Mailboxes (Bulk Mode)
PowerShell command Syntax
|
1 |
$Users = Get-Mailbox -ResultSize unlimited -Filter {(RecipientTypeDetails -eq 'UserMailbox')} $users | %{Set-MailboxRegionalConfiguration $_.Identity -TimeZone <"Time Zone"> } |
PowerShell command Example
|
1 |
$Users = Get-Mailbox -ResultSize unlimited -Filter {(RecipientTypeDetails -eq 'UserMailbox')} $users | %{Set-MailboxRegionalConfiguration $_.Identity -TimeZone "Pacific Standard Time" } |
2.2 – Set Time zone + Language to ALL Mailboxes (Bulk Mode)
PowerShell command Syntax
|
1 |
$Users = Get-Mailbox -ResultSize unlimited -Filter {(RecipientTypeDetails -eq 'UserMailbox')} $users | %{Set-MailboxRegionalConfiguration $_.Identity -TimeZone <"Time Zone"> –Language <Language Code>} |
PowerShell command Example
|
1 |
$users = Get-Mailbox -ResultSize unlimited -Filter {(RecipientTypeDetails -eq 'UserMailbox')} $users | %{Set-MailboxRegionalConfiguration $_.Identity -TimeZone "Pacific Standard Time" –Language en-US } |
2.3 – Correct Time Zone setting for Mailbox with wrong time zone (Bulk Mode)
PowerShell command Syntax
|
1 2 3 |
$MymailBoxes = Get-Mailbox ForEach ($ExamineDmailbox in $MymailBoxes){ $regionalconfig = Get-MailboxRegionalConfiguration –identity $examinedmailbox.identity if ($regionalconfig.timezone -ne <"Time Zone"> ){ Set-MailboxRegionalConfiguration -identity $examinedmailbox.identity -TimeZone <"Time Zone"> -confirm:$False } } |
PowerShell command Example
|
1 2 3 |
$Mymailboxes = Get-Mailbox ForEach ($examinedmailbox in $Mymailboxes){ $regionalconfig = Get-MailboxRegionalConfiguration –identity $examinedmailbox.identity if ($regionalconfig.timezone -ne "Pacific Standard Time" ){ Set-MailboxRegionalConfiguration -identity $examinedmailbox.identity -TimeZone "Pacific Standard Time" -confirm:$False } } |
3. Display Information about Time Zone and Language
3.1 – Display a list of time zones you can use
PowerShell command Syntax
|
1 |
Get-ChildItem "HKLM:\Software\Microsoft\Windows NT\CurrentVersion\Time zones" | FL pschildname |
3.2 – Display information about Time Zone and Language for a specific user
PowerShell command Syntax
|
1 |
Get-MailboxRegionalConfiguration <Identity> |
PowerShell command Example
|
1 |
Get-MailboxRegionalConfiguration John |
3.3 – Display Time zone and Language settings for all users
PowerShell command Syntax
|
1 |
$Users = Get-Mailbox -ResultSize unlimited -Filter {(RecipientTypeDetails -eq 'UserMailbox')} $Users | Get-MailboxRegionalConfiguration |
Additional reading
- Set Language and Time Zone for all OWA users in Office 365
- Time zone settings are incorrect or missing for multiple mailboxes in Office 365
Language code
List of Time zone
PowerShell command syntax – Office 365 | Article series index
It is important for us to know your opinion on this article
Greg
04/23/2018 at 11:10 pmIs it too much to ask to find the global time zone codes that MS uses in Exchange Online? I constantly fight these errors in my scripts:
Cannot process argument transformation on parameter ‘TimeZone’. Cannot convert value “Eastern
European Time” to type “Microsoft.Exchange.Data.Storage.Management.ExTimeZoneValue”. Error: “The
time zone specified is not valid.”