Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Bulk Office 365 - Set Time Zone, Date Format, Time Format and Language PowerShell

Posted on 2014-12-15
1
Medium Priority
?
419 Views
Last Modified: 2015-01-19
Hi,

I have the following script:

$users = Get-Mailbox -ResultSize unlimited -Filter {(RecipientTypeDetails -eq 'UserMailbox')} 
$users | %{Set-MailboxRegionalConfiguration $_.Identity -TimeZone "GMT Standard Time" –Language en-EN -DateFormat "dd.MM.yyyy" -TimeFormat "HH:mm"}

Open in new window


This will set all mailboxes to GMT and English. I am trying to do a bulk group from a CSV, is this possible? Also Language English more than one version, how to ensure the correct English language is picked?

Regards,

introlux
0
Comment
Question by:introlux
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 19

Accepted Solution

by:
Raheman M. Abdul earned 2000 total points
ID: 40500208
$langCode= 2057     # This is language code for English United Kingdom. For more codes see : https://www.cogmotive.com/blog/office-365-tips/set-language-and-time-zone-for-all-owa-users-in-office-365

$users =import-csv c:\temp\userMailboxes.csv
$users | %{Set-MailboxRegionalConfiguration $_.MailboxIdentity -TimeZone "GMT Standard Time" –Language  $langCode -DateFormat "dd.MM.yyyy" -TimeFormat "HH:mm"}
                                  

Open in new window

first column should have MailboxIdentity

MailboxIdentity
mailbox1
mailbox2
mailbox3
....
0

Featured Post

Protect Your Retail Business and Reputation

Wi-Fi access doesn't just impact your business & customer experience, it can also affect your security.  Join us for an informative webinar to learn more about the top threats and trends impacting retail today, and the key solutions to protecting retail networks and reputations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New style of hardware planning for Microsoft Exchange server.
Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question