List all teams and teams members in Microsoft Teams in the tenant

List all teams and teams members in Microsoft Teams in the tenant and exports the results in a CSV.

• PnP PowerShell
• CLI for Microsoft 365

Copied

$adminSiteURL = "https://domain-admin.sharepoint.com/"
$userName = "user@domain.onmicrosoft.com"
$password = "********"
$secureStringPwd = $password | ConvertTo-SecureString -AsPlainText -Force 
$creds = New-Object System.Management.Automation.PSCredential -ArgumentList $userName, $secureStringPwd
$dateTime = "_{0:MM_dd_yy}_{0:HH_mm_ss}" -f (Get-Date)
$basePath = "E:\Contribution\PnP-Scripts\TeamsInformation\Logs\"
$csvPath = $basePath + "\TeamReports" + $dateTime + ".csv"
$global:TeamReports = @()
$siteURL = "https://domain.sharepoint.com/"

Function Login() {
    [cmdletbinding()]
    param([parameter(Mandatory = $true, ValueFromPipeline = $true)] $creds)
 
    #connect to O365 admin site
    Write-Host "Connecting to Tenant Admin Site '$($adminSiteURL)'" -f Yellow 
  
    Connect-PnPOnline -Url $adminSiteURL -Credentials $creds
    Write-Host "Connecting successfully!..." -f Green 
}
Function GetTeamsInformation {
    try {
        Write-Host "Getting teams information..."  -ForegroundColor Yellow
        #get teams information    
        $teams = Get-PnPTeamsTeam 

        Write-Host "Getting teams information successfully!"  -ForegroundColor Green
        try {
            Write-Host "Getting teams user information..."  -ForegroundColor Yellow 	 
            foreach ($team in $teams) { 
                #get users as per teams  			
                $teamsUsers = Get-PnPTeamsUser -Team $team.DisplayName  
               
                foreach ($teamsUser in $teamsUsers) {
                    $global:TeamReports += New-Object PSObject -Property ([ordered]@{  
                            'Team ID'                           = $team.GroupId
                            'Team MailNickname'                 = $team.MailNickname              
                            'Team Name'                         = $team.DisplayName 
                            'Team Description'                  = $team.Description
                            'Team GroupId'                      = $team.GroupId   
                            'Team Allow Create Update Channels' = $team.GuestSettings.AllowCreateUpdateChannels   
                            'Team Allow Delete Channels'        = $team.GuestSettings.AllowDeleteChannels               
                            'Team Visibility'                   = $team.Visibility
                            'User Id'                           = $teamsUser.Id 
                            'User Email'                        = $teamsUser.UserPrincipalName 
                            'User Name'                         = $teamsUser.DisplayName
                            'User Type'                         = $teamsUser.UserType                                      
                        })
                } 
            } 
            Write-Host "Getting teams user information successfully!"  -ForegroundColor Green	 						
        } 
        catch {
            Write-Host "Error in getting teams user information:" $_.Exception.Message -ForegroundColor Red                 
        } 
    }	 
    catch {
        Write-Host "Error in getting teams information:" $_.Exception.Message -ForegroundColor Red                 
    }  	
    Write-Host "Exporting to CSV..."  -ForegroundColor Yellow 
    $global:TeamReports | Export-Csv $csvPath -NoTypeInformation -Append
    Write-Host "Exported to CSV successfully!"  -ForegroundColor Green	 
}

Function StartProcessing {
    Login($creds); 
    GetTeamsInformation         
}

StartProcessing

Check out the PnP PowerShell to learn more at: https://aka.ms/pnp/powershell

Contributors

Author(s)
Chandani Prajapati

Disclaimer

THESE SAMPLES ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.