Microsoft 365

Microsoft Teams: List all Teams, Team Members and Team Channels

Everyone is talking about Microsoft Teams at this time. Me too. So I decided to focus more and more on this cloud technology, in particular the automation of it. In this blog post I will show you how you can get a list of all your teams, team members and team channels of your tenant at once to get a perfect overview of your environment. Let’s slip into it.

The Objective

We want to see this screen. A nice overview of all teams, team users and team channels.

The Code

Copy the code below into PowerShell ISE or Visual Studio Code and run it. The code will detect whether the MSTeams Module is installed. If it is not installed, the script will install the right module for you.

<#

.SYNOPSIS 
Lists all Microsoft Teams by name, team members and team channels.
 
.DESCRIPTION 
Copy this code into an editor of your choosing 
(recommended: PowerShell ISE or VS Code)
 
.NOTES 
Author: Patrick Gruenauer | Microsoft MVP PowerShell
Web: https://sid-500.com 

#>

# Check if Teams Module is installed. If not, it will be installed


If (-not (Get-Module -ListAvailable | Where-Object Name -eq 'MicrosoftTeams' ))

{

  Install-Module -Name MicrosoftTeams -Force -AllowClobber

}

# Connect to Microsoft Teams

Connect-MicrosoftTeams

# List all Teams and all Channels

$ErrorActionPreference = "SilentlyContinue"

$allteams = Get-Team
$object = @()

foreach ($t in $allteams) {

    $members = Get-TeamUser -GroupId $t.GroupId

    $owner = Get-TeamUser -GroupId $t.GroupId -Role Owner

    $channels = Get-TeamChannel -GroupId $t.GroupId 

    $object += New-Object -TypeName PSObject -Property ([ordered]@{

        'Team'= $t.DisplayName
        'GroupId' = $t.GroupId
        'Owner' = $owner.User
        'Members' = $members.user -join "`r`n"
        'Channels' = $channels.displayname -join "`r`n"
    
        })
        
}
Write-Output $object

That’s it for today. Thank you for reading this article.

See also

PowerShell String Manipulation: Swap Lines

In this article I will show you how you can swap lines. I will use an example and show you what is important. Let’s dive in. Consider the following example code: First, we delete all files named file*.txt in your home folder. Then we create a new file with two lines. As you can see,…

Understanding the trap Statement in PowerShell

In PowerShell, error handling is a crucial aspect of writing robust and reliable scripts. One of the powerful features to manage errors gracefully is the trap statement. The trap statement allows you to define a block of code that runs whenever a terminating error occurs in your script. This can be particularly useful for logging…

Understanding ErrorAction Parameter in PowerShell

Error handling is an important part of scripting and automation, and PowerShell provides robust tools for managing errors efficiently. One of the key features for error management in PowerShell is the ErrorAction parameter. This blog post will dive into the ErrorAction parameter, explaining its usage and providing practical examples to illustrate its usage. Let’s start.…

3 replies »

  1. great thanks
    just in this part

    $object += New-Object -TypeName PSObject -Property ([ordered]@{

    i know you managed the “ordered” method

    but i obtainied great result without the need of order with this instead.

    $object+=[pscustomobject]@{

    also another question, if you export to CSV with that format you have is working? have you tried?

    Like

  2. Learning a great deal from your blogs. Being a newbie using powershell I always tend to look forward to new posts.
    I’m struggling with enabling users to Teams enterprise voice and adding them one by one a Number etc. using the SetCSOnline, GrantCSOnline voice routing policy.

    Liked by 1 person

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.