An issue regarding time zones of Date and Time values retrieved from Exchange Server using Power Shell RRS feed

  • Question

  • Hello folks,

    I need your help as I'm pretty new in MS Exchange and Power Shell technologies.

    So here is my question...

    How can I retrieve Date and Time values listed below in UTC using Exchange Power Shell console remotely (the remote server might be in different time zone):

    •   Last Successful Sync (Get-ActiveSyncDeviceStatistics cmdlet)
    •   Last Inspected Log Time (Get-MailboxDatabaseCopyStatus cmdlet)
    •   Last Account Stat Date (Get-MailboxDatabase cmdlet)
    •   Last Logon TimeLast Modified (Get-MailBox cmdlet)

    Please provide correct Power Shell query part related to timezone's handling. 

    Thanks in advance!

    Monday, December 23, 2013 1:12 PM

All replies

  • What about: 

    Get-MailboxDatabaseCopyStatus | Select-Object DatabaseName, @{Name="LastInspectedLogTime";Expression={($_.LastInspectedLogTime.ToUniversalTime())}}

    Can It be the answer to my question???

    Monday, December 23, 2013 1:37 PM