Use case: Use this procedure to create a report that identifies disabled users who still have active Microsoft 365 licenses assigned. This helps reclaim unused licenses and maintain accurate subscription management.
About report templates
A report template defines what the report shows (type) and who it targets (scope). Once a template is created, it can be reused to generate new reports or review results from previous runs. The scope of an existing template can be updated at any time, but the type cannot be changed.
To create a report that identifies disabled users with Microsoft 365 licenses, do the following:
- Go to Entra ID, right-click Reports, and select New Report Template.
- Set the Category to Licenses, set the Type to DisabledUsers, and click Next.
- Configure the Scope to narrow the focus of the report or leave it blank to include all users, then click Create.
- Click Run to execute the report immediately.
- Once the report completes, double-click it to view and filter the results.
This report type (Licenses → DisabledUsers) is quite fast and typically completes in just a few seconds.
To search and filter the report
- Use the Search field to search across all report columns in real time.
- To filter on a specific column, use
[ColumnName]=[search phrase]. - For column names containing multiple words, omit the spaces. You can shorten a column name as long as you include enough characters to identify it uniquely.
- For example, use
Licenses=E5or the shorterlic=e5to find users with licenses containing “E5”. - Combine searches across multiple columns, e.g.
lic=e5 cou=den, to identify users with an E5 license and Country set to Denmark.
To export the report data
- Select the rows you wish to export (CTRL + A to select all).
- Press CTRL + C to copy and CTRL + V to paste into Excel, Notepad, or another tool.
Other Report Types
How to Create a Report: Identify Core Microsoft 365 Workloads Not Being Used
How to Create a Report: Delegated Access to Mailboxes
How to Create a Report: Inactive Users With Microsoft 365 Subscriptions
How to Create a Report: User MFA Configuration and Readiness
How to Create a Report: Mailbox and Archive Sizes
