Generate and Email Teams Reports Using Graph PowerShell

Whether you're a Microsoft 365 admin overseeing dozens—or even hundreds—of Microsoft Teams, or you're simply trying to stay on top of team usage, ownership, and activity, reporting plays a vital role. And what better way to automate this than with Graph PowerShell scripts that not only generate Teams reports but also email them directly to your inbox?

Let’s walk through why and how you can use Graph PowerShell to automate your Teams reporting tasks, and link out to detailed scripts you can use right away!

Why Generate and Email Teams Reports Using Graph PowerShell?

Relying solely on GUI tools like the Microsoft Teams admin center can be time-consuming—especially if you manage multiple teams across departments. With Graph PowerShell, you can:

• Automate routine reports
• Customize filters and output
• Email reports directly to admins or stakeholders
• Save time and minimize human error

How to Generate and Email Teams Reports Using Graph PowerShell

Each of the scripts below is purpose-built for a specific reporting scenario, ensuring that you get exactly the data you need, when you need it.

• Generate and Email Microsoft Teams Report

This script fetches a complete list of all Microsoft Teams in your tenant and emails the report to a designated recipient. It’s perfect for weekly or monthly audits.

👉 View the full guide to generate and email a complete Teams report

• Generate and Email Recently Created Teams Report

Need visibility into newly created teams over the past few days or weeks? This script pulls those records and mails them—ideal for tracking shadow IT or unapproved teams.

👉 How to email a report of recently created Teams

• Generate and Email Recently Deleted Teams Report

This script helps you track deleted Teams using audit logs and emails a summary report. It’s useful for recovery planning and understanding deletion trends.

👉 Track and email recently deleted Microsoft Teams

• Generate and Email Archived Teams Report

Archived Teams aren't deleted, but they’re in read-only mode. This script retrieves those archived Teams and emails the list for compliance or reactivation decisions.

👉 Send archived Teams report via email

• Generate and Email Empty Teams Report

Ever wondered which Teams are just shells with no members? This script pulls all such empty Teams and emails a report—great for cleaning up unused spaces.

👉 Email a report of empty Microsoft Teams

• Generate and Email Teams Owners Report

Keep tabs on Team ownership with this script—it identifies owners for each Team and emails the results. This ensures accountability and helps during audits.

👉 Generate and email Microsoft Teams owners report

• Generate and Email Public Teams Report

This script filters and reports only the Public Teams in your organization—those discoverable by all users. It’s useful for monitoring access exposure.

👉 How to send a report of Public Teams

• Generate and Email Private Teams Report

Private Teams are not visible to everyone. This script generates a report of all Private Teams and mails it—helpful when reviewing restricted workspaces.

👉 Email a list of Private Microsoft Teams

• Generate and Email HiddenMembership Teams Report

Some Teams have hidden membership visibility enabled for privacy. This script pulls such Teams and emails the report—perfect for sensitive teams or compliance tracking.

👉 Send HiddenMembership Teams report via email

Conclusion

Using Graph PowerShell to generate and email Teams reports puts you in control of your Microsoft 365 environment. Whether you're identifying abandoned teams, auditing ownership, or staying ahead of shadow IT, these scripts deliver actionable insights with just a few lines of PowerShell.

💡 Bookmark this hub or share it with your IT peers—it’ll save hours of manual effort and keep your environment in check!