Forum Discussion

Copper Contributor

Dec 19, 2023

Report SP sites are Private or Public

We have a lot (thousands) of SharePoint sites, how to get a report of [Active Sites > Settings > Privacy]: where it shows if site is Private or Public? Can we export it with Powershell? By the wa...

SharePoint Online

UnderDng007
Dec 28, 2023
Thank you for your answer. I am using the following command to combine the information I needed:

Get-PnPMicrosoft365Group -IncludeOwners -IncludeSiteUrl | Where-Object { $_.Visibility -eq "Public"}

DaveMehr365

MVP

Dec 22, 2023

Hello UnderDng007

i think, you mean Teams or Microsoft 365 Groups, right? A Teams/Goup have a privacy.

You can see and Export Teams settings in your Teams Admin Center:

Or also with PowerShell, here are an example:

https://techcommunity.microsoft.com/t5/microsoft-teams/get-all-teams-and-channel-information-using-powershell/m-p/1312145?WT.mc_id=DX-MVP-5004845

Best, Dave

UnderDng007

Copper Contributor

Dec 28, 2023

Thank you for your answer. I am using the following command to combine the information I needed:

Get-PnPMicrosoft365Group -IncludeOwners -IncludeSiteUrl | Where-Object { $_.Visibility -eq "Public"}

MKumar1252
Copper Contributor
Jun 03, 2024
UnderDng007 I am able to use this command to get Public site detail but its not provide all SharePoint site URL & Owner name . Kindly help me to get all Public site details with URL & owner name.