Microsoft 365 security Retrieve associated SharePoint site URL for Microsoft Teams November 23, 2018 By: Vinko Bedek Last updated: May 19, 2023 3 min read Copied! Find out how to retrieve the associated SharePoint Site URL for Microsoft Teams by reading this guide from our dev lead. Table of contents Option No. 1 - Microsoft Graph APIOption No. 2 - Exchange Online PowershellOption No. 3 - SharePoint admin centerSyskit Point - Your Office 365 and SharePoint ally Recently we needed to retrieve a list of SharePoint site collections associated with our Microsoft Teams.This proved more difficult than we anticipated and could not find a straightforward solution. So in case somebody else stumbles upon this problem here are some things that we tried out. Not saying there isn’t a better way of doing this or there won’t be anything in the future, but the options outlined here work in a more or less acceptable fashion. Option No. 1 – Microsoft Graph API Use the Microsoft Graph API. You can get the list of all Office 365 groups by using the following request: https://graph.microsoft.com/v1.0/groups?$filter=grouptypes/any(i:i eq 'Unified') Once the list is retrieved there is a resourceProvisioningOptions field which will have a ‘Team’ value if it is a Microsoft Team. Unfortunately, you cannot filter by resourceProvisioningOptions directly using the $filter query parameter. Now that you have the Teams you can iterate through all the Team IDs and use the following request to retrieve the SharePoint URL: https://graph.microsoft.com/v1.0/groups/{TeamId}/sites/root/weburl But there is a catch if the Team is private the request above will probably return with a 403 status code. Option No. 2 – Exchange Online Powershell Use Exchange Online Powershell: You will need to either use remote PowerShell Or better yet, install the PowerShell module so you can use modern authentication Once the session is imported you can simply use: Get-UnifiedGroup | select DisplayName, SharePointSiteUrl This solution is good because unlike the graph API this will also return SharePoint URLs for private Office 365 Groups (Teams). You will need to determine which Office 365 Group is actually a team by other means. Option No. 3 – SharePoint admin center The Office 365 Group (which by definition also includes Teams) site collections show up in the new SharePoint admin center. To get the URLs programmatically you can read the DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS SharePoint list located on the admin site. This is the list used as the data source for the site collections list when you look at the network traffic. There are multiple interesting fields in this list including IsGroupConnected, GroupId, SiteUrl, SiteId. The list is also accessible on the web by using the direct URL: https://{yourTenant}-admin.sharepoint.com/Lists/DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECO/DO_NOT_DELETE_SPLIST_TENANTADMIN_VIEW_ALL_SITES.aspx By reading this list directly using CSOM you can retrieve the Group SharePoint Site URLs easily. Or you can use the SharePoint REST api: https://{yourTenant}-admin.sharepoint.com/_api/web/lists/GetByTitle('DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS')/items?$filter=IsGroupConnected eq 1&$select=Title,GroupId,SiteUrl,SiteId With this option, you will also still need to determine which Office 365 Groups are actually a team by other means ie. with the graph API as mentioned in Option 1. Of course, if you have the Team object ID then you can simply compare with the GroupId field. If you by any chance find a more elegant solution, please notify us. Syskit Point – Your Office 365 and SharePoint ally Control the security of your Office 365 and SharePoint environment with Syskit Point: List all Microsoft Teams and their associated site collections and Office 365 Groups in a tenant Grant, transfer, and copy SharePoint permissions in bulk List all permissions by a single user or SharePoint group Control the external access to your sites, Microsoft Teams, and OneDrive accounts Discover, secure, and control M365 Manage your company’s Microsoft 365 ecosystem with Syskit Point, a scalable platform that will help you govern and secure your environment while giving you deep visibility into your entire inventory. Try for free Subscribe to our Newsletter Thank you for joining our community! Related Posts Microsoft 365 governance Share smarter: Microsoft 365 oversharing solutions Vlad and Drew discuss Microsoft 365 oversharing and how you can effectively man… February 29, 2024 10 min read Microsoft 365 security SharePoint permissions governance Read the full blog post to find out the benefits of SharePoint permissions mana… September 7, 2017 10 min read Microsoft 365 security SharePoint Online's Shared With column: Explained and demystified SharePoint Online allows you to modify the document library by adding additiona… November 30, 2018 3 min read