Coming from the fact that we have a challenge when it comes to downloading the full list of Azure AD users from Azure AD portal if you have large number of users as this attribute is not available either in AzureAD or MSOnline modules, Get-AzureADUsers.ps1 PowerShell script resolves this challenge as it retrieves Azure AD users with their last sign in date.

• Make sure to have 'c:\temp' folder

Download and run the Get-AzureADUsers.ps1 script from this GitHub repo.

• To retrieve Azure AD users with their last sign-in details.
• To generate a CSV report with the result.

PowerShell console output:

CSV output:

No. It just retrieves data.

No, its enough to have Azure AD free license.

Get-AzureADUsersLastSignIn script retrieves the following details for each user in the tenant:
Object ID, Display Name, User Principal Name, Account Enabled, onPremisesSyncEnabled, Created DateTime (UTC), Last Success Signin (UTC)

No, the script does not require any PowerShell module.