Get all users and their last sign in date and time

[merill]

The sign in activity is currently not available in the v1 version. Use Select-MgProfile beta before running this.

Get-MgUser -Property "userPrincipalName,signInActivity" | ForEach-Object{ Write-Host $_.UserPrincipalName "-->" $_.signinactivity.lastSignInDateTime}

Sample output

AdeleV@pora.onmicrosoft.com --> 21/11/2022 9:36:24 pm
AlexW@pora.onmicrosoft.com --> 21/6/2022 2:13:32 am
annaj@elapora.com -->
bagula@elapora.com -->
chris.green_yopmail.net#EXT#@pora.onmicrosoft.com -->
DiegoS@pora.onmicrosoft.com --> 30/9/2022 6:28:07 am
draker_yopmail.net#EXT#@pora.onmicrosoft.com --> 25/4/2022 1:33:59 am

[BamOidaFixMan]

Hi, I also build something similar, but I get also last sign in when it fails. Do you know any option where i can only see successfully logins?