8 Must-Have Groups Scripts for Microsoft 365 Administrators

Microsoft 365 groups sit at the core of many services—Outlook, SharePoint, Teams, Planner, and more. As usage grows, administrators often struggle with visibility, ownership, hygiene, and governance across different group types such as Microsoft 365 groups, security groups, and distribution lists.

To make group administration easier, Graph PowerShell–based scripts can automate reporting and highlight potential issues before they become problems. Below are 8 must-have Microsoft 365 Groups scripts that every administrator should keep handy.

Must-Have Microsoft 365 Groups PowerShell Scripts

• Generate empty Microsoft 365 groups report
  Over time, unused or abandoned Microsoft 365 groups accumulate in tenants. This script identifies groups that have no members, helping administrators clean up unused resources and reduce clutter.

👉 Read more: Generate empty Microsoft 365 groups report using Graph PowerShell

• Email disabled users in groups report
  

Disabled user accounts lingering in group memberships can cause access and compliance concerns. This script finds disabled users across groups and emails a consolidated report to administrators.

👉 Read more: Email disabled users in groups report

• Fetch and email recently created Microsoft 365 groups
  New groups are created frequently in active tenants. This script lists recently created Microsoft 365 groups and emails the report, allowing admins to monitor group creation trends and enforce governance policies early.

👉 Read more: Fetch and email recently created Microsoft 365 groups

• Multiple groups owner report
  Clear ownership is critical for accountability. This script generates a report showing group owners across multiple Microsoft 365 groups, making it easier to audit ownership and identify ownerless or poorly managed groups.

👉 Read more: Multiple Microsoft 365 groups owner report

• Fetch and email user group memberships
  Understanding which groups a user belongs to is essential for troubleshooting access issues and audits. This script fetches group memberships for a specific user and emails the report to administrators.

👉 Read more: Fetch and email user group memberships

• Email distribution groups report
  Distribution groups are still widely used for email communication. This script retrieves all distribution groups in the tenant and emails a structured report to administrators for review and documentation.

👉 Read more: Email distribution groups report

• Find empty distribution groups
  Empty distribution groups often indicate obsolete or forgotten resources. This script identifies distribution groups with no members, helping admins safely clean up unused mailing lists.

👉 Read more: Find empty distribution groups using Graph PowerShell

• Fetch security groups report
  Security groups play a key role in access control and licensing. This script fetches all security groups in the tenant, giving administrators a clear overview of security-related group configurations.

👉 Read more: Fetch security groups using Graph PowerShell

Why these scripts matter

Together, these scripts help administrators:

• Maintain group hygiene
• Identify unused or misconfigured groups
• Improve ownership accountability
• Strengthen security and compliance
• Reduce manual reporting effort

They also fit naturally into a Groups governance and reporting strategy, making them ideal for automation and scheduled reporting.

Ready-to-use reporting without scripting

If you’re tired of building custom Graph PowerShell scripts just to make sense of Microsoft 365 data, take a look at the M365 Reporting Tool – Community Edition. It provides ready-to-use reports without dealing with Graph API endpoints or scripting overhead.

👉 https://github.com/m365corner/m365corner-reporting-tool-community-edition.git