Why use this template?
Use this free PowerShell script when you need to export licensed member users. It is generated locally and can be reviewed before you run it yourself in your own PowerShell session.
The template uses Microsoft.Graph.Users and requires User.Read.All, Organization.Read.All. Output: CSV report. Level: Beginner. Action: Read-only. Risk: Low.
Review before running
The script is generated in your browser. Read it before you run it, and test it outside production first. “Read-only” describes the script itself; anything you add around it can still change data.
Generate the script
- Open the template in the PowerShell Builder.
- Enter the requested values and review the module, permissions, output and risk.
- Generate the script, read it carefully, and test it outside production before use.
The script is generated locally in your browser. Nothing needs to be uploaded to Opselith.
Generate Export licensed Entra users →How to use this result
Use this report to export licensed Microsoft Entra member users and quickly review which member accounts currently have one or more assigned licenses.
When this helps
- Create a simple licensed-user baseline before a licensing review or Microsoft 365 migration.
- Find member accounts that currently have assigned licenses and compare them with HR or ownership records.
- Capture a repeatable CSV snapshot for periodic license-assignment checks.
How to read the result
- The template returns Microsoft Entra member users where the assignedLicenses collection is not empty and reports the number of assigned licenses for each user.
- LicenseCount is only a count of assigned license objects. It does not identify the SKU names, enabled service plans or whether the licensed services are actively used.
Things to check
- Guest users and member users with no assigned licenses are outside this report by design.
- A license assignment does not prove that the assignment is still required or correctly sized for the user. Review business need and SKU details separately.
What to do next: Compare the licensed-user list with your current ownership or HR source, then use a SKU-level license report when you need to decide which products or service plans should remain assigned.
Official references