Why never-signed-in users are the fastest win
Finance sees license counts. You see the truth: seats assigned to people who never logged in, pre-hire accounts that were never disabled, duplicate test users, or licenses copied from a template.
This is narrower and higher-intent than a general license cleanup. It is also the easiest reclaim to defend in a budget meeting.
How to find never-signed-in licensed users manually
- Microsoft 365 admin center → Users → Active users: add Sign-in status column
- Entra ID → Users: filter users with licenses; sort by Last sign-in
- Microsoft Graph: query users with
assignedLicensesandsignInActivity; Microsoft documentslastSignInDateTime,lastNonInteractiveSignInDateTime, andlastSuccessfulSignInDateTimeon thesignInActivityresource - Cross-check disabled accounts: disabled users with active licenses are reclaimable immediately
- Export to spreadsheet: UPN, display name, licenses, created date, last sign-in, enabled/disabled
What good looks like
- No enabled user holds a paid license for more than 7 days without sign-in (except documented pre-hire staging)
- Disabled accounts have zero license assignments within 24 hours of offboarding
- HR triggers a dated onboarding record tied to license assignment
How to reclaim licenses safely
- Sort by SKU cost: prioritize E5 and Business Premium because each reclaimed seat has immediate dollar impact.
- Confirm ownership: check HR or manager records before removing licenses from enabled accounts; pre-hire accounts may be intentional.
- Use the admin center for small batches: Microsoft documents unassigning licenses from Users → Active users → Manage product licenses or from Billing → Licenses.
- Use Graph PowerShell for repeatable cleanup: for larger batches, Microsoft documents
Set-MgUserLicensewith-RemoveLicensesfor removing SKU IDs. - Check group-based licensing: if a license is inherited from a group, remove the user from the licensing group or change the group assignment instead of editing the user directly.
- Document savings: record SKU, user, reclaimed date, and monthly savings so finance can verify the impact.
- Fix the process: tie license assignment to start date and offboarding completion so this does not recur.
Pair with inactive and disabled-user checks
Never-signed-in is one slice. Also review:
- Licensed users inactive 90+ days
- Disabled users still holding seats
- Oversized SKUs (E5 where E3 suffices)
Tenant Hawk surfaces never-signed-in licensed accounts in the cost category and puts a dollar estimate on reclaimable spend. Run a free scan to get the list in minutes instead of exporting spreadsheets.