Forum Discussion

Naligurtan's avatar
Naligurtan
Brass Contributor
Dec 15, 2023

Get site owners and site admins

Hello All,

 

There are over 5000 SharePoint sites in my MS365 Tenant.

I am using SharePoint Online.

I retrieved/extracted a report/list of sites that have "Everyone expect external users" group.

1000 SharePoint sites have "Everyone expect external users" group.

I have this report in excel/csv.

 

My question is this:

How can get a list of site owners and site admins for those 1000 SharePoint sites that have "Everyone expect external users" group?

 

Looking forward to hearing from you.

 

Thanks

Permissions
powershell
SharePoint Online
Sites
  • jcgonzalezmartin's avatar
    jcgonzalezmartin
    MVP
    Dec 15, 2023

    Hi,

    Two options here:

    (1) PowerShell Script (I have not make a search, but maybe the script has already been created by somebody else

    (2) Third party tools that allows to create custom audit reports such as Sharegate or similar

Resources