Today, I wanted to get a full overview of all the Microsoft Teams teams sites that I have in my tenant. I decided to put PnP PowerShell to the test for this.

I found that Get-PnPTenantSite didn’t include my team sites and therefore I had to look for different options. Quite quickly I found a solution. I had to go through the following steps:

  • Connect to my SharePoint Admin Center site.
  • Get a list called: DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS
  • Display the list items in this list

 

Connecting to the Admin Center site

To connect to the Admin Center site I’m running the following command:

Connect-PnPOnline https://mytenant-admin.sharepoint.com

Get the list

First I need to get the site. Then I load my lists just to have a look at which lists exist:

$site = Get-PnPSite
$site.Context.Load( $site.RootWeb)
$site.Context.ExecuteQuery()

$web = $site.RootWeb

$site.Context.Load( $web.Lists)
$site.Context.ExecuteQuery()

Now a quick look at $web.Lists shows me that there is a list with a very long name: DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS

Not sure who came up with this name for a list. But it is very noticeable.

Now I get my list:

$list = $web.Lists[5]

Display The List Items

Ok, we are nearly there. Just get all the list items and spit out the SiteUrl

for ($x = 0; $x -lt $list.ItemCount; $x++ )
{
$item = $list.GetItemById($x)

$site.Context.Load( $item)
$site.Context.ExecuteQuery()

Write-Host $item.FieldValues.SiteUrl : $item.FieldValues.TemplateTitle
}

Yes I know I could clean up the above code a bit. e.g. use a Query and query the list for the list items. But for simplicity I kept the code as simple as possible.

Ok, So now I’ve got all of my site collections listed with their templates used. All the sites marked Team site are my modern team sites.

So now we need to find a way to filter out the Modern Team sites that were created within SharePoint rather than Microsoft Teams. ( Thanks Paul Keijzers for pointing this out
!). Unfortunately there isn’t an option for this yet!

Advertisements