List and Export External Users to CSV


This windows application allows SharePoint Online Administrators to list and export all external users to CSV.  You can run the script to iterate all site collections or against the list provided as CSV.  You can double click on a row to open external user management in internet explorer.  Next steps for me would be to allow you to remove the user without going to the site.

I have tested this tool with tenants of 4K and 10K sites without any issue.

Note: The Root Site Collection URL must be SharePoint Admin Url. Not the root site collection url as asked

#To Generate the Input CSV

$SitesToAudit

= Get-SPOSite -Limit All | Where-Object {$_.SharingCapability –ne “Disabled”}

$SitesToAudit

| Select Url | Export-Csv -Path C:\Scripts\InputCSV.csv -NoTypeInformation -Verbose -Force

image

https://gallery.technet.microsoft.com/office/List-and-Export-SharePoint-d670dc40