17,402 total views, 2 views today
In this article, we will learn about how to retrieve hub sites and associated sites using PnP Powershell and Office 365 admin center URL or SharePoint admin center URL.
PnP PowerShell script to get all sites connected to a hub site:
- Using PnP PowerShell get all associated or connected sites to a particular hub site.
- Get a master report for all sites and their hub sites from the SharePoint online tenant.
PnP PowerShell script to get all sites connected to hub site: Test
Let’s see the exported hub sites report – how does it look like?
Master report for all hub sites in the SharePoint Online tenant:
All associated sites connected to a single hub site report.
View all sites that are connected to a hub site using SharePoint admin center URL:
We need to generate a view to listing down the hub site report using the hub site association.
Login to the SharePoint admin center URL.
If we navigate to SharePoint online admin center URL, we will get the below SharePoint admin center page. Then need to click on the “Active Sites” link from the left-side panel.
Then from the “Active sites” dashboard click on “Hub” -> Filter by Hub -> then select your hub site – this will list down all sites that are connected to that particular hub site.
For an example – I have selected my hub site “SP Hub Site”
Now – we can see all sites that are connected to the hub site “SP Hub Site”
Similarly, we can export this report in CSV file and we can filter that site report file from the local excel to have a list of all the sites that are part of the same Hub.
To do this we need to follow the below steps:
From the “Active sites” dashboard click on the “Export” button. This will export all SharePoint online sites in the CSV file to your local download folder.
We will get the active sites report as below – from there we can filter as per our need.
Thus, in this article we have learned the below:
- Get all sites associated with a SharePoint Online Hub Site – using SharePoint Online Admin center URL.
- Get all sites associated with a SharePoint Online Hub Site using PnP PowerShell.
- How to retrieve hub sites and associated sites using PnP Powershell.
- How to use the Get-PnPTenantSite command.
- Create a hub site in SharePoint Online.
- How to use Get-PnPHubSite.
- How to export the report in CSV file using the export-CSV command.
- Learn about hub site in SharePoint Online
- Navigation in SharePoint online hub site
- Getting started with PnP PowerShell
- Get hub sites and associated sites using PnP PowerShell
- SharePoint Online Automation – O365 – Download files from a document library using PowerShell CSOM
- SharePoint Online Automation – O365 – Create multiple items in a list using PowerShell CSOM
- SharePoint Online Automation – O365 – Upload files to document library using PowerShell CSOM
- SharePoint Automation: PowerShell script to get remote server information
- SharePoint Online Automation – O365 – Send email from SharePoint online Using CSOM PowerShell script
- SharePoint Online Automation – O365 – Update document library metadata using PowerShell CSOM
- Create modern team site using PnP PowerShell – SharePoint
- In 2 steps convert a classic SharePoint page to modern using PnP
- In 4 steps access SharePoint online data using postman
- Learn SharePoint online administration step by step