Opselith
POWERSHELL / MICROSOFT.GRAPH.USERS
FreeBeginnerRead-onlylow

Export unlicensed Entra users

Export Microsoft Entra member users with no assigned licenses to CSV with PowerShell for licensing and account review.

Open in PowerShell Builder →Browse all scripts

Generated locally in your browser · Review before running · Opselith does not connect to your tenant

What this PowerShell script does

Exports unlicensed member users.

Requirements

  • CSV output path - Example: C:\Temp\report.csv

Environment

  • Module: Microsoft.Graph.Users
  • Permissions: User.Read.All
  • Output: CSV report
  • Context: Microsoft Graph PowerShell
  • Risk: Low
Review before you run The script is generated locally. Test outside production first.
NEXT STEP

Ready to generate

Configure Export unlicensed Entra users in the Builder, review the generated PowerShell and run it yourself in your own PowerShell session.

Configure this script →Open Builder
More about this script

Why use this template?

Use this free PowerShell script when you need to export unlicensed 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. 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

  1. Open the template in the PowerShell Builder.
  2. Enter the requested values and review the module, permissions, output and risk.
  3. 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 unlicensed Entra users →

How to use this result

Use this report to find member users whose assignedLicenses collection is empty without changing user or license assignments.

When this helps

  • Review unlicensed member accounts before license cleanup, onboarding checks or account lifecycle work.
  • Create a simple CSV of display name, UPN and enabled state for follow-up with service owners.

How to read the result

  • A returned user is a Member account with no values in assignedLicenses at the time of the query.
  • Unlicensed does not automatically mean unused, safe to disable or unnecessary; some accounts can still access services that do not require an assigned SKU.

Things to check

  • Guest users are intentionally excluded by the Member filter.
  • The report does not explain why a user is unlicensed or whether a license was recently removed.

What to do next: Confirm account ownership and business need before disabling users or changing license assignments.

Related tasks

Official references

Before you runModule, permissions, inputs, compatibility and script checks
OPS / SCRIPT DETAILS

Script details

Exports unlicensed member users. Review these details before generating or running the script.

entraexportuserslicensing
Generated here. Run by you.Opselith does not connect to your tenant or run PowerShell. After generating, review the script and run it in your own PowerShell session.

What it works with

Module: Microsoft.Graph.Users

Microsoft Graph PowerShell lets the script work with Microsoft Entra and Microsoft 365 data through Microsoft Graph.

Context: Microsoft Graph PowerShell

Compatibility: PowerShell 7 is the supported target for this cloud template.

Permissions and changes

Permissions: User.Read.All

Risk: Low

Read-only: designed to collect information without intentionally changing the target environment.

Changes: Read-only. The script reads data and does not intentionally change the target environment.

Inputs

  • CSV output path - Example: C:\Temp\report.csv (Required)

What to expect

Output: CSV report

Expect a CSV file at the path you choose. Open it in Excel or another CSV viewer and review the rows.

Example: C:\Temp\report.csv

This template is in the Free library and is generated locally in your browser. Opselith does not run it; you review and run the script in your own PowerShell session.

Example use

Exports unlicensed member users.

Enter the required values in the Builder, review the generated script and confirm the output before running it.

Before you run: Make sure your account has User.Read.All. Check that the Microsoft.Graph.Users PowerShell module is available and that you are using the supported PowerShell version. Review the generated script and output path, then test outside production first.
Script checksWhat has been verifiedQA reviewed
Static checksPassed
PSScriptAnalyzerPending
Real-world run testNot yet recorded
Last checkedNot yet recorded

Real-world run results are shown only after Opselith reviews and accepts a tester report.

Tester: report a result →
TEST STATUSWhat Opselith has checked

Last reviewed: 28 Aug 2026

PSScriptAnalyzer: Awaiting a release PSScriptAnalyzer gate that includes this script. No analyzer pass is claimed yet.

Pending or Not yet recorded means there is no accepted result on file yet. A passed analyzer check does not mean the script has been run in a real tenant.

NEXT IN THE LIBRARY

Scripts for similar admin tasks and Microsoft services.

Browse Microsoft Entra PowerShell scripts →
POWERSHELLExport licensed Entra usersentra · export · usersPOWERSHELLExport disabled Entra usersentra · export · usersPOWERSHELLExport Entra guest usersentra · export · users