Last Login dates for all Guests using PowerShell

[coxygt]

So I need to be able to report on all guest accounts on my companies tenant, to see the last time they logged on.  AzureADSignin Logs are no good as they only cover last 30 days, I know somewhere within Azure, I have found one guest account where the last login was during 2021, but I need to capture this for all guest accounts?

Is this even possible?

Thanks in advance for any help.

[#2 · Accepted solution]

Here's a sample script on that that I wrote a while back: https://www.michev.info/Blog/Post/2968/reporting-on-users-last-logged-in-date-in-office-365

To do it via PowerShell, use the Graph SDK:

Select-MgProfile beta
Get-MgUser -All:$true -Filter {userType eq 'Guest'} -Property UserPrincipalName,SignInActivity | select UserPrincipalName,@{n="LastLoginDate";e={$_.signInActivity.lastSignInDateTime}}

[#3]

Thanks Vasil,
Have downloaded, just need to check the permissions etc.

[#4]

@coxygt You can easily find the last logon details of a guest users using a single cmdlet 'Get-MgUser'.
 

Get-MgUser -All -Filter "UserType eq 'Guest'" -Property SignInActivity | Select-Object userprincipalname -ExpandProperty SignInActivity | Format-List

 For additional information about guest users management, check: https://m365scripts.com/microsoft365/a-quick-approach-to-manage-guest-users-in-microsoft-365-using-p...