Data is key! How to Analyze your M365 Usage?

Inactive Users
To receive the last login date information to determine the inactive users could be one via PowerShell script.

1. Install the Required PowerShell Module

First, you need to install the AzureAD module if you haven’t already. Open PowerShell as an administrator and run:

Install-Module AzureAD

2. Connect to Azure AD

Next, connect to your Azure AD tenant:

Connect-AzureAD

You’ll be prompted to enter your Microsoft 365 admin credentials.

3. Retrieve Last Login Information

You can use the Get-AzureADAuditSignInLogs cmdlet to get the last login date for users. Here’s a basic script to get the last login date for all users and export it to a CSV file:

# Connect to Microsoft Graph
Connect-MgGraph -Scopes "User.Read.All", "AuditLog.Read.All"

# Initialize variables
$nextPage = $true
$requestUrl = "/beta/users?select=userPrincipalName,id,userType,signInActivity&top=100"
$csvFilePath = "C:\temp\UserLogins.csv"

# Loop through paged responses
while ($nextPage) {
Write-Host "." -NoNewline
   # Get the current page of users
   $response = Invoke-MgGraphRequest -Method GET -Uri $requestUrl
   # Select the required properties
   $userLogins = $response.value | Select-Object @{Name="UserPrincipalName";Expression={$_.userPrincipalName}}, 
   
@{Name="Id";Expression={$_.id}}, 
             @{Name="UserType";Expression={$_.userType}}, 

@{Name="LastSignIn";Expression={$_.signInActivity.lastSignInDateTime}}

   # Append the current page of results to the CSV file
   $userLogins | Export-Csv -Path $csvFilePath -NoTypeInformation -Append

   # Check if there is a next page
   if ($response.'@odata.nextLink') {
       $requestUrl = $response.'@odata.nextLink'
   } else {
       $nextPage = $false
   }
}

# Output completion message
Write-Host "Export completed. The data has been written to $csvFilePath."

This script will export the user principal names and their last login dates to a CSV file¹.

4. Run the Script

Save the script with a .ps1 extension, for example, Get-LastLoginDates.ps1. To run the script, open PowerShell, navigate to the directory where the script is saved, and execute:

.\Get-LastLoginDates.ps1