Microsoft 365 Free Reporting Tool – Teams With Shared Channels Report

Shared channels in Microsoft Teams allow organizations to collaborate across teams and even across tenants without requiring users to switch Teams. While this capability improves collaboration, it also introduces new governance considerations. Admins often need to answer an important question: Which Teams in my tenant contain Shared Channels?

Unfortunately, identifying this information using native Microsoft admin tools is not straightforward. The Teams With Shared Channels Report, available in the M365 Free Reporting Tool, provides instant visibility into Teams that contain shared channels—without scripting or manual filtering.

How to Generate Teams With Shared Channels Report?

Let’s review the available approaches and their limitations.

1. Using Microsoft 365 Admin Center

The Microsoft 365 Admin Center does not provide visibility into shared channel usage within Teams.

❌ Limitations

• No support for identifying Teams with Shared Channels
• No reporting capability for channel types
• No filtering or export option


Because of these limitations, admins cannot easily track shared channel usage from this portal.

2. Using Microsoft Teams Admin Center

The Microsoft Teams Admin Center offers slightly better visibility but still falls short for reporting purposes.

Admins can:

• Add the Shared Channels column to the Teams list.

However:

❌ Limitations

• Teams without shared channels are still included in the results
• The shared channels column may show 0, requiring manual filtering
• No way to display only Teams with shared channels
• No clean reporting view


In large environments, this approach becomes inefficient.

3. Using Graph PowerShell

Graph PowerShell can be used to identify Teams that contain shared channels by retrieving channel information and filtering by membership type.

Sample Graph PowerShell Script

                                                
# Connect to Microsoft Graph
Connect-MgGraph -Scopes "Group.Read.All","Channel.ReadBasic.All"

# Get all Teams-enabled groups
$teams = Get-MgGroup -All `
    -Filter "resourceProvisioningOptions/Any(x:x eq 'Team')" `
    -Property Id, DisplayName

$report = foreach ($team in $teams) {
    $channels = Get-MgTeamChannel -TeamId $team.Id -All -ErrorAction SilentlyContinue
    $sharedChannels = $channels | Where-Object { $_.MembershipType -eq "shared" }

    if ($sharedChannels.Count -gt 0) {
        [PSCustomObject]@{
            TeamName = $team.DisplayName
            TeamId   = $team.Id
            SharedChannelCount = $sharedChannels.Count
        }
    }
}

$report | Export-Csv "C:\TeamsWithSharedChannels.csv" -NoTypeInformation
                                                
                                            

🔎 What this script does

• Retrieves all Teams-enabled groups
• Fetches channels for each Team
• Filters channels where MembershipType = shared
• Outputs only Teams that contain shared channels

⚠️ Downsides of PowerShell

• Requires Graph and PowerShell knowledge
• Multiple API calls per Team
• Script maintenance required
• Manual CSV export and formatting

While powerful, this approach is not ideal for administrators looking for a quick report.

4. Using M365Corner Microsoft 365 Free Reporting Tool

With the M365Corner Microsoft 365 Free Reporting Tool, generating the Teams With Shared Channels Report becomes effortless.

👉 You can generate the Microsoft Teams With Shared Channels Report at the click of a button.



Why this helps admins

• No scripts required
• Exclusive listing of Teams that contain shared channels
• Clear visibility into cross-team collaboration spaces
• One-click CSV export
• Clean and consistent UI

This dramatically quickens reporting, giving administrators instant insight into Teams using shared channels and helping them maintain governance and visibility.

Explore Teams With Shared Channels Report

• 🔗 Learn More About Teams With Shared Channels Report

https://m365corner.com/m365-free-tools/microsoft-teams-with-shared-channels-report.html
Understand what the report includes and how it helps monitor shared channel usage.

• 🔗 Explore All Reports in the M365 Free Reporting Tool

https://m365corner.com/m365-free-tools/m365corner-reporting-tool.html
Discover all reports available in the M365 Free Reporting Tool.

• 🔗 Download the Community Edition

https://github.com/m365corner/m365corner-reporting-tool-community-edition.git
Start using the M365 Free Reporting Tool Community Edition today.