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 · Accepted solution]

No. Use the report in the O365 admin center -> Reports -> Usage -> Active users.

[#3]

Thanks, Vasil. That will have to do, but what I really needed was to be able to sort on user type (internal user, guest user, administrator etc.)

[#4]

I think this is what you need.

The above functionality is available in AdminDroid Office 365 Reporter.

[#5]

This might give you what you're after...

https://community.spiceworks.com/scripts/show/2290-last-log-in-time-and-date-powershell-script-for-o...

[#6]

The provided script gives you the last login information of users who have Exchange Online license whereas the requirement is to display "last logon time" of unlicensed users as well.

[#7]

Hi Robert,

I tested the script it also provides the logon times for "Unlicensed Users" as well and exports them to a .CSV.

[#8]

Once you've logged in and authenticated against your Office 365 tenant, you can then use the below commands.

# Connects you to Windows Azure Active Directory

Connect-MsolService

# Gets Unlicenced users and lists the "DisplayName, LastLogonTime and LastLogoffTime"

Get-MsolUser -UnlicensedUsersOnly | Foreach {Get-MailboxStatistics $_.UserPrincipalName | Select DisplayName, LastLogonTime, LastLogoffTime}

[#9]

What about users who don't have mailboxes? I have a number of users for whom we have disabled the Exchange Online license. How can I get their logon statistics?

[#10]

Just a warning that using the Get-MailboxStatistics cmdlet to get this information is highly unreliable (see @Tony Redmond's great blog on that here: https://www.petri.com/get-mailboxstatistics-cmdlet-wrong). The Office 365 usage reports is really the better answer here.

[#11]

It's not only unreliable, it's impossible. Get-MailboxStatistics only returns statistics for mailboxes, but I specifically need logon statistics for people who do not have mailboxes.