Get site owners and site admins

Brass Contributor

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

2 Replies

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

@jcgonzalezmartin  I already knew that. I don't know how to create a PowerShell script for this.