Forum Discussion
Getting the owners for all SharePoint sites in tenant using Powershell
The term "Owners" is a bit misleading in SharePoint, what do you need?
#1 - Owners of the MS365 Group linked to the Teams Site? These users have Admin permissions on the Site.
#2 - Users in the SharePoint Group "Owners"? These users have only Full Control permissions.
For #1 you can run this script: https://github.com/Barbarur/NovaPointPowerShell/blob/main/Solutions/Report/Permissions%20report%20of%20a%20SharePoint%20Online%20Site.md#user-with-full-control-at-the-site-level
For #2 you can run this other script: https://github.com/Barbarur/NovaPointPowerShell/blob/main/Solutions/Report/Admins%20of%20all%20Sites%20Collections%20report.md
An easier approach would be using the free open-source app NovaPoint: https://github.com/Barbarur/NovaPoint
You can easily obtain these reports with few clicks. One of the report solutions on this app is "All Site Collections and Subsites" which includes the Admins and users with all type of Site access permissions, including users inside MS365/Security Groups.
Here is more information about how this Solution works: https://github.com/Barbarur/NovaPoint/wiki/Solution-Report-SiteAllReport
- The repository is still alive; https://github.com/Barbarur/NovaPointPowerShell
The ones I shared before are under "Solutions" > "Reports". I don't add the full link to avoid the same issue as above, as this repository is less static on the naming.
You can have a look also to NovaPoint: https://github.com/Barbarur/NovaPoint. I have it improve the permissions report solution.- Hey, Thanks for your help, Link is very helpful. However, I followed below link to get all the Sharepoint groups in all the sites under a tenant.
