đź”§ New: User Management Graph PowerShell Toolkit

Simplify user tasks like bulk creation, updates, password resets, deletions, license checks & more — all from one place.

🚀 Launch Toolkit

Generate Useful Teams Reports Using PowerShell

What is Microsoft Teams Reporting?

Microsoft Teams reporting is all about keeping track of how Teams are being created, used, and managed across your Microsoft 365 tenant. Reports provide admins with valuable insights—like who owns which team, which ones are active, or whether unused teams are piling up. These reports are crucial for governance, compliance, and ensuring a secure collaboration environment.


Why Generate Microsoft Teams Related Reports?

Admins need reports to answer day-to-day operational questions:

  • Which Teams are active and which ones aren’t?
  • Who owns each Team?
  • Have any Teams been recently deleted or archived?

By generating reports, administrators can maintain oversight, prevent sprawl, enforce policies, and ensure Teams are used effectively. Reports also help with audits, license planning, and long-term governance strategies.


How to Generate Microsoft Teams Reports?

You can generate Teams reports in multiple ways:

  • Using Microsoft 365 Admin Center
  • Navigate to Reports > Usage to access high-level reports on Teams activity. These are helpful but limited when it comes to detailed insights.

  • Using Microsoft Teams Admin Center
  • The Teams Admin Center provides built-in reports for policy compliance, device usage, and meeting analytics. However, it doesn’t always allow custom reports.

  • Using Graph PowerShell
  • With Graph PowerShell, you can build customized Teams reports and even automate their generation and delivery via email. This is especially useful for recurring tasks, large environments, or when you need granular control.

Here are some popular Teams reporting scripts you can use:


  • Generate & Email All Teams Report
  • This script pulls a complete list of all Teams in your tenant and emails the report to the administrator. It’s perfect for maintaining an inventory of Teams and ensuring no unauthorized Teams slip through.

  • Generate & Email Public Teams Report
  • Public Teams can be joined by anyone in the organization. This report helps admins identify all public Teams so they can validate if this openness is intentional and aligns with organizational security policies.

  • Generate & Email Private Teams Report
  • Private Teams restrict membership, so only invited users can join. This script helps track all private Teams, ensuring they are properly governed and monitored for compliance.

  • Generate & Email Archived Teams Report
  • Archived Teams are locked for editing but preserved for reference. This report allows admins to identify archived Teams and manage their lifecycle effectively, avoiding clutter.

  • Generate & Email Empty Teams Report
  • Empty Teams (Teams without members) consume resources without serving any purpose. This script highlights such Teams, helping admins clean them up or repurpose them.

  • Generate & Email Teams Owners Report
  • Every Team must have at least one owner to manage membership and settings. This report ensures each Team has active ownership, preventing orphaned Teams.

  • Generate & Email Recently Created Teams Report
  • This script identifies Teams that have been recently created. It’s useful for monitoring new activity, spotting potential sprawl, or tracking Teams created for new projects.

  • Generate & Email Recently Deleted Teams Report
  • Deleted Teams may still hold critical data in their lifecycle window. This report helps admins track which Teams have been removed and ensure no important resources were lost.

Conclusion

Microsoft Teams reports are a cornerstone of governance and compliance in any M365 environment. While the Admin Center provides some high-level insights, Graph PowerShell scripts give you flexibility and automation, letting you tailor reports to your exact needs. By using the scripts above, you can stay on top of Teams activity, owners, lifecycle, and compliance—without manual effort.



Did You Know? Managing Microsoft 365 applications is even easier with automation. Try our Graph PowerShell scripts to automate tasks like generating reports, cleaning up inactive Teams, or assigning licenses efficiently.

Ready to get the most out of Microsoft 365 tools? Explore our free Microsoft 365 administration tools to simplify your administrative tasks and boost productivity.

© Your Site Name. All Rights Reserved. Design by HTML Codex