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

PowerShell: Securing Passwords in Scripts by encrypting with the Security Identifier (SID)

Months before I wrote a post about passwords in scripts. In this post I solved the “problem” with encryption using certificates. This time I will show how to encrypt passwords in scripts with the SID (Security Identifier) of the user. Before we start here is the link to the blog post mentioned: PowerShell: Encrypt and store […]

by Patrick Gruenauer 25. January 202125. January 2021

PowerShell Kurs: 29.03.2021 – 03.04.2021 mit Durchführungsgarantie (via MS Teams)

Liebe Follower! Der nächste PowerShell Kurs findet online statt und hat Durchführungsgarantie. Ich freue mich auf zahlreiche Teilnahme und spannende Tage! Mehr Infos hier: PowerShell Training – Patrick Grünauer (sid-500.at) Lg P. Gruenauer

by Patrick Gruenauer 16. January 202116. January 2021

Create Hyper-V VMs with PowerShell (Single, Multiple)

In case you have Hyper-V in use, then you are in the right place. In this blog post I will show you how to create VMs in Hyper-V. I will also show how to create multiple Hyper-V VMs at the same time using PowerShell. It’s great to see PowerShell showing what it can do here […]

by Patrick Gruenauer 12. January 202114. January 2021