O365 / Exchange Time Zones and Regions

%3CLINGO-SUB%20id%3D%22lingo-sub-2787921%22%20slang%3D%22en-US%22%3EO365%20%2F%20Exchange%20Time%20Zones%20and%20Regions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2787921%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3EI'm%20bit%20of%20an%20Exchange%20(and%20Powershell)%20novice%2C%20hoping%20to%20get%20some%20help%20with%20reporting%20and%20updating%20the%20Language%2C%20Date%20Formats%2C%20Time%20Zones%20etc%20for%20all%20of%20our%20users%20(~450).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFound%20a%20Powershell%20command%20to%20get%20all%20the%20users%20current%20settings%2C%20made%20a%20couple%20of%20changes%20to%20export%20it%20to%20CSV%2C%20the%20CSV%20contained%20a%20few%20extra%20fields%20I%20didn't%20want%20so%20included%20the%20select%20statement.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20what%20I%20ended%20up%20with%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%24Users%20%3D%20Get-Mailbox%20-ResultSize%20unlimited%20-filter%20%7B(RecipientTypeDetails%20-eq%20'UserMailbox')%7D%3CBR%20%2F%3E%24Users%20%7C%20Get-MailboxRegionalConfiguration%20%7C%20Select-Object%20Identity%2C%20Language%2C%20DateFormat%2C%20TimeFormat%2C%20TimeZone%20%7C%20Export-CSV%20-NoTypeInformation%20-Path%20C%3A%5Ctemp%5Cregions.csv%20-Encoding%20UTF8%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20time%20I%20ran%20it%20with%20the%20resultsize%20as%2010%20and%20all%20seemed%20to%20work%20fine.%26nbsp%3B%3C%2FP%3E%3CP%3EChange%20it%20to%20unlimited%2C%20left%20it%20to%20run%20and%20came%20back%20to%20%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%22WARNING%3A%20Micro%20delay%20applied.%20Actual%20delayed%3A%2049373%20msecs%2C%20Enforced%3A%20True%2C%20Capped%20delay%3A%2049373%20msecs%2C%20Required%3A%20False%2C%20Additional%20info%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaw%20a%20couple%20of%20options%20online%20to%20get%20around%20this%20(%3CSPAN%3EStart-Sleep%20or%26nbsp%3BRobustCloudCommand)%2C%20but%20a%20bit%20lost%20how%20to%20apply%20either%20to%20what%20I%20already%20have.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20there%20a%20better%20way%20to%20extract%20the%20information%20I%20need%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHave%20I%20impacted%20the%20performance%20of%20the%20Powershell%20above%20by%20including%20the%20select%20statement%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ELastly%20to%20do%20a%20bulk%20update%20I%20was%20looking%20to%20use%20the%20following%2C%20will%20I%20experience%20the%20same%20Mirco%20delay%20issue%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%24MymailBoxes%3C%2FSPAN%3E%20%3D%20%3CSPAN%20class%3D%22%22%3EGet-Mailbox%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EForEach%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24ExamineDmailbox%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ein%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%24MymailBoxes%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%7B%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%24regionalconfig%3C%2FSPAN%3E%20%3D%20%3CSPAN%20class%3D%22%22%3EGet-MailboxRegionalConfiguration%3C%2FSPAN%3E%20%E2%80%93%3CSPAN%20class%3D%22%22%3Eidentity%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%24examinedmailbox%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E.%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3Eidentity%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3Eif%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24regionalconfig%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E.%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3Etimezone%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E-ne%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%22Time%20Zone%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%26gt%3B%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%7B%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3ESet%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E-MailboxRegionalConfiguration%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E-identity%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%24examinedmailbox%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E.%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3Eidentity%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E-TimeZone%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%22Time%20Zone%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%26gt%3B%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E-confirm%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%24False%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%7D%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%7D%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2787921%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExchange%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi Everyone,

I'm bit of an Exchange (and Powershell) novice, hoping to get some help with reporting and updating the Language, Date Formats, Time Zones etc for all of our users (~450).

 

Found a Powershell command to get all the users current settings, made a couple of changes to export it to CSV, the CSV contained a few extra fields I didn't want so included the select statement.

 

Here's what I ended up with:

 

$Users = Get-Mailbox -ResultSize unlimited -filter {(RecipientTypeDetails -eq 'UserMailbox')}
$Users | Get-MailboxRegionalConfiguration | Select-Object Identity, Language, DateFormat, TimeFormat, TimeZone | Export-CSV -NoTypeInformation -Path C:\temp\regions.csv -Encoding UTF8

 

First time I ran it with the resultsize as 10 and all seemed to work fine. 

Change it to unlimited, left it to run and came back to :

"WARNING: Micro delay applied. Actual delayed: 49373 msecs, Enforced: True, Capped delay: 49373 msecs, Required: False, Additional info"

 

Saw a couple of options online to get around this (Start-Sleep or RobustCloudCommand), but a bit lost how to apply either to what I already have.

 

Is there a better way to extract the information I need?

Have I impacted the performance of the Powershell above by including the select statement?

Lastly to do a bulk update I was looking to use the following, will I experience the same Mirco delay issue?

$MymailBoxes = Get-Mailbox
ForEach ($ExamineDmailbox in $MymailBoxes){ $regionalconfig = Get-MailboxRegionalConfigurationidentity $examinedmailbox.identity
if ($regionalconfig.timezone -ne <"Time Zone"> ){ Set-MailboxRegionalConfiguration -identity $examinedmailbox.identity -TimeZone <"Time Zone"> -confirm:$False } }
0 Replies