List of Teams with uses Connectors

JFM_12 -

To identify which Teams are using connectors and to get a list of those connectors, you can use PowerShell with Microsoft Graph API. 

Here’s a detailed approach to achieve this:

Using Microsoft Graph API with PowerShell

1. Register an Application in Azure AD:

   • Go to the Azure Portal.
   • Navigate to Azure Active Directory > App registrations > New registration.
   • Provide a name, and for redirect URI, you can use https://localhost (if you're not using it, it won't affect the process here).
   • After registration, go to API permissions, add Microsoft Graph API with Group.Read.All and Team.ReadBasic.All permissions (and grant admin consent).
   • Go to Certificates & secrets and create a new client secret. Note down the Client ID, Tenant ID, and Client Secret.

2. Use PowerShell to Query Microsoft Graph API:

   Install the Microsoft.Graph PowerShell module if you haven't already:
   Install-Module Microsoft.Graph

   Use the following PowerShell script to get the Teams and their connectors:

   # Define parameters
   $tenantId = "YOUR_TENANT_ID"
   $clientId = "YOUR_CLIENT_ID"
   $clientSecret = "YOUR_CLIENT_SECRET"
   
   # Authenticate to Microsoft Graph
   $scope = "https://graph.microsoft.com/.default"
   $tokenRequestBody = @{
   Grant_Type = "client_credentials"
   Client_Id = $clientId
   Client_Secret = $clientSecret
   Scope = $scope
   }
   
   $tokenResponse = Invoke-RestMethod -Method Post -Uri "https://login.microsoftonline.com/$tenantId/oauth2/v2.0/token" -ContentType "application/x-www-form-urlencoded" -Body $tokenRequestBody
   $accessToken = $tokenResponse.access_token
   
   # Define the Graph API endpoint to get the list of Teams
   $teamsUrl = "https://graph.microsoft.com/v1.0/teams"
   
   # Get the list of Teams
   $teams = Invoke-RestMethod -Method Get -Uri $teamsUrl -Headers @{ Authorization = "Bearer $accessToken" }
   
   # Iterate through each team to get connectors
   foreach ($team in $teams.value) {
   $teamId = $team.id
   $teamName = $team.displayName
   
   # Get connectors for the team
   $connectorsUrl = "https://graph.microsoft.com/v1.0/teams/$teamId/installedApps"
   $connectorsResponse = Invoke-RestMethod -Method Get -Uri $connectorsUrl -Headers @{ Authorization = "Bearer $accessToken" }
   
   # Filter connectors
   $connectors = $connectorsResponse.value | Where-Object { $_.teamsApp.displayName -ne $null }
   if ($connectors.Count -gt 0) {
   Write-Output "Team: $teamName"
   foreach ($connector in $connectors) {
   Write-Output " Connector: $($connector.teamsApp.displayName)"
   }
   }
   }

   
   

   This script retrieves a list of Teams and their connectors by querying Microsoft Graph API. You may need to handle pagination if you have many Teams.
   
   Important Note: -The existing Microsoft 365 (previously called Office 365) connectors across all cloud platforms are nearing deprecation, and the creation of new Microsoft 365 connectors will soon be blocked. For more information on the schedule and how the Workflows app provides a more flexible and secure experience, see retirement of Microsoft 365 connectors within Microsoft Teams.
   
   Document -Webhooks and connectors - Teams | Microsoft Learn