Getting the List of all sites/ sub-sites and their owners using PnP

Question

Hi,&nbsp;I am trying to get the list of all the SharePoint sites/ sub-sites that I have access to in my tenant in SharePoint Online. Also I have to make a list of all the sites/ sub-sites with their Owners. What is the best way to achieve this?If script is needed, PnP is preferred.&nbsp;I am trying to achieve this using PnP but haven't figured out yet. Here's what I have done:1. Get list of all sites in the tenant :&nbsp;Get-pnptenantsite2. For each site collection, find the list of sites and subsites:&nbsp;get-pnpsubwebs -recurse3a. I don't know how to get the list of users in each subsite. I tried&nbsp;get-pnpusers, but it is giving the users at top level site collection not sub-sites.3b. I can find the site admin using IsAdmin is true, but can't find the Owners (both individuals and group)&nbsp;Thanks,Nabin

naveen karla · Answer

Did you try using Search webpart or Search REST API

You can use search with either the Search Web Parts or using REST for search.

Search WebPart:

Find all Site Collections: “contentclass=STS_Site”
Find all Webs (top level sites and subsites): “contentclass=STS_Web”

http://techtrainingnotes.blogspot.com/2015/07/using-sharepoint-serach-to-find-sites.html

Search REST API:

http://yourserver/sites/yoursite/_api/search/query?querytext='contentclass=STS_Site'
http://yourserver/sites/yoursite/_api/search/query?querytext='contentclass=STS_Web'

https://msdn.microsoft.com/en-us/library/office/jj163876.aspx

You could also use Graph API to get these details

https://www.c-sharpcorner.com/article/retrieve-site-collections-and-subsites-using-microsoft-graph-api/

Owner for each site can be fetched using

https://graph.microsoft.com/beta/sites/{site-id}?$select=*,drive&$expand=drive

nabin pokharel · Answer

Thanks&nbsp;Naveen Karla&nbsp;,I haven't approached through Search or REST API or Graph API. I will give it a shot.-Nabin

anders brunholm sylvest · Answer

Hi,&nbsp;&nbsp;Using SPO Pnp PowerShell, you should be able to get a list of web users, after iteration webs using this:&nbsp;&nbsp;https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/get-pnpuser?view=sharepoint-ps&nbsp;Iterate through "get-pnpsubwebs -recurse" and then call "Get-PnpUser" for each web.&nbsp;&nbsp;

officekundig · Answer

However there are subsites available I am not able to call these using the commands above.
No Subsites detected.
I just updated the online pnp powershell but had no positive affect.
Please inform me how to check if there are subsites and which using PnP Powershell

juanfiletti · Answer

Good

Forum Discussion

Getting the List of all sites/ sub-sites and their owners using PnP

Share

Resources