Opselith
POWERSHELL / MICROSOFT.GRAPH.GROUPS
ProIntermediateRead-onlylow

Export Entra group membership counts

Export Microsoft Entra groups with their membership counts and core group properties to CSV with PowerShell.

Open in PowerShell Builder →Browse all scripts

Generated securely after server-side Pro license validation · Review before running · Opselith does not connect to your tenant

What this PowerShell script does

Exports groups with direct member counts using Graph count queries instead of downloading every member.

Requirements

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

Environment

  • Module: Microsoft.Graph.Groups
  • Permissions: GroupMember.Read.All
  • Output: CSV report
  • Context: PowerShell 7 · Microsoft Graph
  • Risk: Low
Review before you run The script is generated securely after server-side Pro license validation. Test outside production first.
NEXT STEP

Ready to generate

Configure Export Entra group membership counts 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 PowerShell template when you need to export groups with direct member counts using Graph count queries instead of downloading every member. It can be previewed in the Builder; Pro access is required to generate it for your own environment.

The template uses Microsoft.Graph.Groups and requires GroupMember.Read.All. Output: CSV report. Level: Intermediate. Action: Read-only. Risk: Low.

Review before running

The script remains preview-only until Pro access is enabled. Review it before running it, and test it outside production first. “Read-only” describes the script itself; anything you add around it can still change data.

Preview the script

  1. Open the template in the PowerShell Builder.
  2. Review the purpose, requirements, permissions, output and risk.
  3. Activate Pro when you are ready to generate the full script, then test it outside production.

Pro templates remain previewable before purchase or activation. No tenant connection is required. When you generate a Pro script, only the configuration values needed for that template are sent to Opselith after license validation.Preview Export Entra group membership counts →

How to use this result

Use this report to compare group size and basic group characteristics across the tenant without exporting every member row.

When this helps

  • Find unusually large, empty or unexpectedly small groups for follow-up.
  • Create a lightweight group-size inventory before migration or governance review.

How to read the result

  • MemberCount is a count returned for each group; it does not show who the members are or why they have access.
  • MailEnabled, SecurityEnabled and GroupTypes help distinguish group characteristics but do not replace workload-specific governance checks.

Things to check

  • Per-group count failures are kept in the Error column instead of silently becoming zero.
  • A zero count is only meaningful when the corresponding Error value is empty.

What to do next: Open the member export for groups whose count or type needs investigation before changing membership.

Related tasks

Official references

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

Script details

Exports groups with direct member counts using Graph count queries instead of downloading every member. Review these details before generating or running the script.

entraexportgroupsreporting
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.Groups

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

Context: PowerShell 7 · Microsoft Graph

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

Permissions and changes

Permissions: GroupMember.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 Pro library. Generating the full script requires eligible Pro or tester access. Opselith receives only the values needed to build the script; it does not connect to your tenant, run PowerShell or store the generated script. You review and run the result in your own PowerShell session.

Example use

Exports groups with direct member counts using Graph count queries instead of downloading every member.

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 GroupMember.Read.All. Check that the Microsoft.Graph.Groups 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: 10 Sept 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 Entra group ownersentra · export · usersPOWERSHELLExport Entra group typesentra · export · groupsPOWERSHELLFind Entra dynamic groupsentra · find · groups