Here is a quick one liner to gain the “Logon” and “LogOff” times for all mailboxes hosted on a Exchange 2007 mailbox server. All mailboxes and their access times will be exported into a .csv file for reference.
Note: Replace %ServerName% with a valid Exchange 2007 Mailbox Server in your Org.
Get-Mailbox | Where{$_.ServerName -eq '%ServerName%'} | Get-MailboxStatistics | Select-Object ServerName,StorageGroupName,DatabaseName,DisplayName,LastLogonTime,LastLogOffTime,LastLoggedOnUserAccount | Export-CSV "C:\MailboxAccessTimes.csv" -NoTypeInformation
Hope this helps.
All information is provided on an AS-IS basis, with no warranties and confers no rights.
Tags: Exchange 2007, Get-Mailbox, Get-MailboxStatistics, PowerShell
