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 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 Related Posts Microsoft 365 security IT & employee offboarding: Crucial considerations for protecting your business External attacks and departing employees can be a serious data safety threat. C… April 19, 2022 5 min read Microsoft 365 security Office 365 Sensitivity Labels Learn what Office 365 sensitivity labels are, who can use them, what are their … October 12, 2021 12 min read Microsoft 365 security Microsoft SharePoint permission levels explained Find out what are different SharePoint permission levels, how they work and how… February 7, 2023 10 min read