List all users' last login date

[Jakob Rohde]

Is it possible, using PowerShell, to list all AAD users' last login date (no matter how they logged in)? I have found a couple of scripts that check the last mailbox login, but that is not what we need, because we also want to list unlicensed users.

[#2]

Hi @mdiloreto,
I'm fine thanks and hope the same for you.
Sorry for the late answer.
Yes, that is correct. An empty value or inconsistent mean that the user has never been signed-up against Azure AD.

Best Regard

[#3]

While this is good information for AAD, it appears to be limited to the past 90 days. We are looking for something static and retrievable like LastLogonTimestamp in AD or LastLogonTime in Exchange Online MailboxStatistics.

[#4]

@Donald Mosteller 

The Microsoft Graph API now supports the resource property signInActivity in users end-point, this resource exposes the lastSignInDateTime property which shows the last time a user made a successful sign-in. Fetching signInActivity property requires an Azure AD Premium P1/P2 license and the AuditLog.Read.All permission. The following request retrieves user details along with signInActivity property.

#GET Request
https://graph.microsoft.com/beta/users?$select=displayName,signInActivity

You can refer the below post to know more details about how to find and export Last login date for all Azure AD Users using PowerShell.

• https://morgantechspace.com/2021/09/find-last-login-date-for-all-azure-ad-users-using-powershell.htm...

[#5]

The thread that keeps on keeping on....

Here is a new page from MS on the topic with all the required information.

https://learn.microsoft.com/en-us/azure/active-directory/reports-monitoring/howto-manage-inactive-us...

[#6]

Hi Jakob,

Sorry, is possible to use one command in PowerShell for extraction the last logon in software Microsoft Project?

Thank you

[#7]

Yes empty mean never logged-in.

[#8]

i ran the script but it's giving me empty results on the LastSignInDate, do you know why this is happening?

[#9]

@Staniko 

i tried this script and it works very well thanks. But I have a problem the results stop after about 100 users. 

[#10]

Hey @everyone,
Because of the paging size change from 1000 to 120, guests maybe be reported incorrectly and deleted. If you are using this script please grab an updated copy and report any bugs!

https://github.com/JBines/Remove-StaleGuests
https://github.com/microsoftgraph/msgraph-sdk-powershell/issues/1898

[#11]

@Kevin Morgan 

Is it possible to to get a last activity date for only guest users? I have about 25k that I need to cleanup and need to determine if they have logged on in the past 90days or more.

thanks

Kevin

[#12]

@Robert Luck At first glance, AdminDroid is the answer to my lastlogin prayers!  Just starting to play with it now.  Thanks!