Forum Discussion

prashantguptag's avatar
prashantguptag
Brass Contributor
Jan 02, 2019

Office 365 Groups report does not bring all sites with template Group#0

Hi,

I am trying to pull Office 365 Groups and all site collections report via PowerShell. This is how I did it:

  • To get details about all O365 groups (please note that I cannot use EXO cmdlets due to some reasons) I am using this query "Get-AzureADMSGroup -All:$True | Where {($_.GroupTypes -eq 'Unified')}" and getting all required details of groups but this does not give associated site urls so I used graph query to get associated site urls of each Office 365 group. So I got the full list of Office 365 groups
  • Then to get all sites information from Tenant I used PnP PS module and I got all required information along with site template name. 

Here is the issue: When I count the no. of sites with template = GROUP#0 returned in second report (via PnP), the count is not the same as no. of groups found in first report. There is a difference around 200. Is there any possibility that Group connected site can be created even without having group type = UnifiedGroup? What am I missing here?

 

-Prashant.

  • Have you tried to get the list of modern sites from the new SPO Admin Center and compare this list against what you get with PS?
    • prashantguptag's avatar
      prashantguptag
      Brass Contributor

      Thanks. I will check that.

      Is there any possibility that we can get the Group details using SPO URL like Alias, group id etc.

      • prashantguptag's avatar
        prashantguptag
        Brass Contributor

        Ok so I got the group details based on SPO site url via site property bag keys "GroupId" and "GroupAlias". I will further investigate this.

Resources