Last Login Details

Question

Hi All

I am using exchange 2016 hybrid environment. we create users in onprem and migrate to exchange online and sometimes i also create users using remote mailbox syntax from onprem. i have a test tenant and i have 70 Office 365 licenses(50 E5 & 20 E3). i am running out of licenses and i dont want to procure any more Office 365 license as it is a test tenant. Now i have a requirement to provision 20 mailboxes. i want to revoke the licenses of the users who have not logged in last 30 days. From Azure AD i can see last sign-in logs. is this the only logs which gives me the details. and lets say i have csv file of the users in the below format. can i import the csv and get the last signin logs

users
user1@Company portal .com
user2@Company portal .co

Answer 1

Hi Glenn,

You can use GraphAPI to extract the information: user-list

or the script:

$LiveCred = Get-Credential  
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection  
Set-ExecutionPolicy RemoteSigned  
Import-PSSession $Session  
(Get-Mailbox) | Foreach {Get-MailboxStatistics $_.Identity | Select DisplayName, LastLogonTime} | Export-CSV $Home\Desktop\LastLogonDate.csv  
Remove-PSSession $Session  

==
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.