Get all Teams and channel information using PowerShell

gcjuw84
Brass Contributor
May 19, 2020
Sebastian Di Cecca

No problem, the final script is below. Before running the script you need to make sure you run Connect-MicrosoftTeams and Connect-ExchangeOnline.

Any problems let me know.

$AllTeamsInOrg = (Get-Team).GroupID $TeamList = @() Write-Output "This may take a little bit of time... Please sit back, relax and enjoy some GIFs inside of Teams!" Write-Host "" Foreach ($Team in $AllTeamsInOrg) { $TeamGUID = $Team.ToString() $TeamGroup = Get-UnifiedGroup -identity $Team.ToString() $TeamName = (Get-Team | ?{$_.GroupID -eq $Team}).DisplayName $TeamOwner = (Get-TeamUser -GroupId $Team | ?{$_.Role -eq 'Owner'}).User $TeamUserCount = ((Get-TeamUser -GroupId $Team).UserID).Count $TeamGuest = (Get-UnifiedGroupLinks -LinkType Members -identity $Team | ?{$_.Name -match "#EXT#"}).Name if ($TeamGuest -eq $null) { $TeamGuest = "No Guests in Team" } $TeamChannels = (Get-TeamChannel -GroupId $Team).DisplayName $ChannelCount = (Get-TeamChannel -GroupId $Team).ID.Count $TeamList = $TeamList + [PSCustomObject]@{TeamName = $TeamName; TeamObjectID = $TeamGUID; TeamOwners = $TeamOwner -join ', '; TeamMemberCount = $TeamUserCount; NoOfChannels = $ChannelCount; ChannelNames = $TeamChannels -join ', '; SharePointSite = $TeamGroup.SharePointSiteURL; AccessType = $TeamGroup.AccessType; TeamGuests = $TeamGuest -join ','} } ####### $TestPath = test-path -path 'c:\temp' if ($TestPath -ne $true) {New-Item -ItemType directory -Path 'c:\temp' | Out-Null write-Host 'Creating directory to write file to c:\temp. Your file is uploaded as TeamsDatav2.csv'} else {Write-Host "Your file has been uploaded to c:\temp as 'TeamsDatav2.csv'"} $TeamList | export-csv c:\temp\TeamsDatav2.csv -NoTypeInformation
- Darkdata
  Copper Contributor
  Sep 17, 2024
  gcjuw84 Greetings, thank you for too for the script. I was having a number of errors which I have worked through, but this last error I am not sure. If anyone can assist me, that would be greatly appreciated.
- SebCerazy
  Iron Contributor
  Feb 06, 2023
  After 10 hours of running the script, eventually all I got is:
  
  Write-ErrorMessage : The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.
  - EnviableOne
    Copper Contributor
    Feb 17, 2023
    90% of the time, its better to filter on the server side, this might work a little faster, and will give you some feedback:
    
    $clock = [System.Diagnostics.Stopwatch]::StartNew()
    write-host "Connecting to MS and loading teams please wait..." -NoNewline
    $AllTeamsInOrg = Get-Team
    $Teamcount = $AllTeamsInOrg.count
    write-host "Teams loaded ("
    $TeamList = @()
    $i = 0
    Write-Host "This may take a little bit of time... Please sit back, relax and enjoy some GIFs inside of Teams!"
    
    Foreach ($Team in $AllTeamsInOrg){
    $i++
    Write-host "Processing Team $i of $teamcount ($($team.displayname)) ..." -NoNewline -ForegroundColor Gray
    $TeamGUID = $Team.groupid
    $TeamGroup = Get-UnifiedGroup -identity $Team.GroupId
    $TeamName = $Team.DisplayName
    $TeamOwner = (Get-TeamUser -GroupId $Team.GroupId -Role Owner).User
    $TeamUserCount = (Get-TeamUser -GroupId $Team.GroupId).Count
    $TeamGuest = (Get-TeamUser -GroupId $Team.GroupId -Role Guest).Name
    if ($TeamGuest -eq $null){
    $TeamGuest = "No Guests in Team"
    }
    $TeamChannels = (Get-TeamChannel -GroupId $Team.GroupId).DisplayName
    $ChannelCount = (Get-TeamChannel -GroupId $Team.GroupId).Count
    $TeamList += [PSCustomObject]@{TeamName = $TeamName; TeamObjectID = $TeamGUID; TeamOwners = $TeamOwner -join ', '; TeamMemberCount = $TeamUserCount; NoOfChannels = $ChannelCount; ChannelNames = $TeamChannels -join ', '; SharePointSite = $TeamGroup.SharePointSiteURL; AccessType = $TeamGroup.AccessType; TeamGuests = $TeamGuest -join ','}
    Write-host "done." -ForegroundColor Green
    }
    
    #######
    
    $pathtest = test-path -path 'c:\temp'
    if ($pathtest) {New-Item -ItemType directory -Path 'c:\temp' | Out-Null
    write-Host 'Creating directory to write file to c:\temp.'
    }
    $TeamList | export-csv c:\temp\TeamsDatav2.csv -NoTypeInformation
    $clock.Stop()
    Write-Host "Completed. Written to: 'c:\temp\TeamsDatav2.csv'" -ForegroundColor Yellow
    Write-Host "$i Teams Loaded, Time taken $($clock.elapsed.ToString("G"))" -ForegroundColor Yellow
- Marcus Tarquinio
  Brass Contributor
  May 04, 2021
  Dears,
  
  Thanks for sharing the script and ideas. I am expanding on this and when I try to find if the user is a member or owner of the Team Channels they belong to using Get-TeamChannelUser as described in the documentation, it does not work.
  https://docs.microsoft.com/en-us/powershell/module/teams/get-teamchanneluser?view=teams-ps
  
  Do anyone know how to get the information if a user is a member or owner of a Team Channel?
  
  Thanks
  
  $MyTeams = Get-Team -User bob@contoso.com
  Foreach ($Team in $MyTeams)
  {
  Get-TeamChannel -GroupId $Team.GroupId
  Get-TeamChannelUser -GroupId $Team.GroupId
  }
  - colynykalphiacom
    Copper Contributor
    Dec 28, 2022
    I am looking for this as well. I need powershell to loop through all Teams, report users access level (eg, owner, member or guest) and then loop through all the channels of that team to export users access level of each channel. And do this for each Teams. Anyone have an example?

Forum Discussion

Get all Teams and channel information using PowerShell

Resources