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 overwiew 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 or 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

$ErrorAction = "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

How to create a NAT-Switch on Hyper-V with PowerShell

NAT is a technology to convert IP addresses. If you have a test environment then it might be necessary that your VMs need an internet connection and that you don’t want to use the external switch for that. In this blog post I will cover this topis and show you how you can create a […]

Neuer Udemy Kurs: Automatisierung mit PowerShell (1/2): Grundlagen

Liebe Follower! Hurra! Mein erster Udemy Kurs ist online. Kurssprache ist Deutsch. Der Kurs richtet sich an PowerShell Neulinge, oder auch an Personen die PowerShell von Grund auf Lernen möchten. Link: https://www.udemy.com/course/automatisierung-mit-powershell-1_3-grundlagen/?referralCode=C4E70BD40A116B304842 Ich freue mich über zahlreiche Teilnahme. Liebe Grüße, Patrick Grünauer

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 Reply to Henry Morales Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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