Patrick Lamber
Patrick Lamber Microsoft Office Development MVP

Return the Office 365 Groups' connected services through PowerShell

The introduction of Office 365 Groups is improving the way Microsoft 365 services are linked together and how the permissions are handled for them. On top of that, you get a consolidated way of handling the life cycle of such services. This consolidation is welcome, on the other hand, service owners want to get an overview of the Office 365 groups linked to their main services.

I started to receive requests such as:

What are the Yammer groups linked with an Office 365 Group and their associated SharePoint Online site?

What are the Teams connected with a group and what are the directly associated services to it?

Based on these requests, I started looking for some reporting capabilities or APIs to answer these questions. Unfortunately, I ended up finding the Azure Active Directory interface for groups when looking at group details. At the bottom of the page, it shows the section Group links providing exactly the information I needed.

I was stuck and opened a premier case to understand the options at our disposal and how to collect this information through API. After a couple of days, I received the feedback that at this moment the only efficient way to get this information is by consuming the Get-UnifiedGroup PowerShell command provided by the Exchange Online Team. The results produced by this commandlet have to be interpreted with this logic:

  • For Microsoft Teams or Yammer, the property is ServiceEndpointUris, if it is empty, this means group is not linked, if it is filled, the URI listed will indicates if it is Yammer or Teams.
  • For SharePoint Online, the property is SharePointSiteUrl, if it is empty, this means group is not linked.
  • For Exchange Online, the property is InboxUrl, if it is empty, this means group is not linked.

I ended up writing a PowerShell script that is extending the objects returned by Get-UnifiedGroup with following properties:

  • HasYammer: indicates if the group is linked with Yammer
  • HasTeams: indicates if the group is linked with Teams
  • HasSharePoint: indicates if the group is linked with SharePoint
  • HasMail: indicates if the group is linked with Exchange
I am using the technique described here to connect to Exchange Online.

comments powered by Disqus