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 -AllowRedirection
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 D:\Lastlogontime.csv
Step 3: Run the following to remove the authentication
# Removes the Session as only 3 sessions are allowed
$importresults = ""
$Session = ""
Add your domain to Office 365 without redirecting your name server records to Office 365
Move your email to Office 365 and keep your current public-facing website
Update DNS records to keep your website with your current hosting provider
Assigning administrator roles
Use Windows PowerShell to manage Office 365
Please check this link for Windows PowerShell cmdlets for Office 365