Forum Discussion

escupham's avatar
escupham
Iron Contributor
Oct 24, 2016

List of SPO sites with external sharing enabled

What's the easiest way to get a list of all SharePoint Online sites that have external sharing enabled?

Sites

5 Replies

  • Viral Naik's avatar
    Viral Naik
    Copper Contributor
    Apr 26, 2018

    https://gallery.technet.microsoft.com/office/How-to-get-sharing-status-d28b8523

  • SanthoshB1's avatar
    SanthoshB1
    Bronze Contributor
    Oct 25, 2016

    You can use the below script to get and export this list easily. 

     

    Get-SPOSite -Detailed |Where-Object {$_.SharingCapability -ne "Disabled"}|select Url,SharingCapability |Export-csv <path>
  • Dean_Gross's avatar
    Dean_Gross
    Silver Contributor
    Oct 24, 2016

    In the O365 Admin Center, go to Resources, choose Sites, the page shows a listing with Sharing Status

    • escupham's avatar
      escupham
      Iron Contributor
      Oct 24, 2016

      Thanks, not sure how I missed that!  Now if we can just get a filter and export option added to that page....

  • escupham's avatar
    escupham
    Iron Contributor
    Oct 24, 2016

    I see you can do a content search in the security center on ViewableByExternalUsers:true AND ContentType:document, but I'm looking for a list of sites only, not documents.

Resources