How to Find SharePoint Sites Associated with Microsoft Teams?

Requirement: Find the SharePoint Online site of the Microsoft Team.

How to Get the Associated SharePoint Online Site of a Microsoft Team?
Every Microsoft teams created have a SharePoint Site associated behind the scenes to store files. To find the SharePoint site of the team,
  • Navigate to the Microsoft team, Click on "Files" tab and you'll find a button "Open in SharePoint"find sharepoint online site of microsoft teams
This opens the SharePoint Online site of the particular Microsoft teams.

Get a List of All Teams and their associated SharePoint Sites
To retrieve the associated SharePoint sites for Microsoft teams, Use this PowerShell script:
#Get Credentials to Connect
$Credential = Get-Credential

#Connect to Microsoft Teams
Connect-MicrosoftTeams -Credential $Credential | Out-Null
  
#Create a session and connect to Exchange
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ `
           -Credential $Credential -Authentication Basic -AllowRedirection
  
#Import the session
Import-PSSession $Session -DisableNameChecking -AllowClobber | Out-Null

#Get All Teams
$Teams = Get-Team | Select DisplayName, GroupId
Write-host "Total Number of Teams Found:"$Teams.Count

#Iterate through Each team and get SharePoint Site URL
ForEach ($Team in $Teams) 
{
    #Collect SharePoint Sites of the teams
    [PSCustomObject] @{
        TeamName      = $Team.DisplayName
        SharePointURL = Get-UnifiedGroup -Identity $Team.GroupId | Select -ExpandProperty SharePointSiteURL
    }
}

This PowerShell gets the list of all Teams and their associated SharePoint Online sites: 

find sharepoint sites of microsoft teams

4 comments:

  1. got an error.

    New-PSSession : [outlook.office365.com] Connecting to remote server outlook.office365.com failed with the following error message : The WinRM client cannot process the request. Basic authentication is
    currently disabled in the client configuration. Change the client configuration and try the request again. For more information, see the about_Remote_Troubleshooting Help topic.
    At C:\Scripts\Get-MSteamsandAssociatedSites.ps1:11 char:12
    + $Session = New-PSSession -ConfigurationName Microsoft.Exchange -Conne ...

    ReplyDelete
    Replies
    1. you might be able to change it using steps - https://www.sharepointdiary.com/2018/08/new-pssession-connecting-to-remote-server-outlook-office365-com-failed.html

      Delete
  2. WinRM basic auth is required to be enabled in order to connect to the PS session

    ReplyDelete
  3. How do you connect when you need to use MFA?

    ReplyDelete

Please Login and comment to get your questions answered!

Powered by Blogger.