POWERSHELL / MICROSOFTTEAMS
ProIntermediateRead-onlylow

Export Teams owner counts

Export Microsoft Teams owner counts and owner names to CSV with PowerShell for governance review.

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

What this PowerShell script does

Exports every Team with its owner count.

Requirements

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

Environment

  • Module: MicrosoftTeams
  • Permissions: Teams Administrator
  • Output: CSV report
  • Context: PowerShell 7 · Microsoft Teams
  • 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 Teams owner counts in the Builder, review the generated PowerShell and run it yourself in your own PowerShell session.

More about this script

Why use this template?

Use this PowerShell template when you need to export every Team with its owner count. It can be previewed in the Builder; Pro access is required to generate it for your own environment.

The template uses MicrosoftTeams and requires Teams Administrator. 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 Teams owner counts →

How to use this result

Use this report to compare owner coverage across every Team instead of only listing Teams with zero owners.

When this helps

  • Find Teams with zero, one or unusually many owners.
  • Create an ownership baseline before governance, migration or organizational change.

How to read the result

  • OwnerCount is the number of owners returned by Get-TeamUser -Role Owner for that Team during the run.
  • The Owners field is a joined display-name summary for review; use the row-level owner export when individual owner records are required.

Things to check

  • An Error value means the owner count could not be determined and should not be interpreted as zero.
  • A healthy owner count does not prove that the listed owners are active or still accountable for the Team.

What to do next: Investigate error rows and zero-owner Teams first, then validate single-owner Teams against your governance standard.

Related tasks

Official references

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

Script details

Exports every Team with its owner count. Review these details before generating or running the script.

teamsexportownershipreporting
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: MicrosoftTeams

MicrosoftTeams lets PowerShell read or manage Microsoft Teams settings.

Context: PowerShell 7 · Microsoft Teams

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

Permissions and changes

Permissions: Teams Administrator

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 every Team with its owner count.

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 Teams Administrator. Check that the MicrosoftTeams 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.