How to get the list for SMTP address and Last connection time for all the users
Summary
This article describes how to use PowerShell Commandlet to get the list for SMTP address and Last connection time for all the users.
Steps to implement the request
Step 1: Run the following to authenticate yourself and import PowerShell commands to your local session:
$LiveCred = Get-Credential$Session = New-PSSession -ConfigurationName Microsoft.Exchange-ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirectionImport-PSSession $Session
Step 2: Run the Commandlet to get the SMTP address and Last connection time for all the users
Commandlet to get SMTP address:
Get-Mailbox | fl EmailAddresses, identity > C:\Emailaddress.csv
Commandlet to get Last connection time:
Get-Mailbox -ResultSize unlimited | Get-MailboxStatistics | select-object identity,lastlogontime,lastlogofftime,DisplayName | sort-object DisplayName -descending | export-csv C:\Lastlogontime.csv
Enjoy