Below is the powershell script to iterate through all Site Collections and get list if External users per site collection. $Sites = Get-SPOSite | select * foreach($Site in $Sites) { Write-Host "Getting External Users from " $Site.Url Get-SPOUser -Site $Site.Url | Where-Object { $_.LoginName -like "*EXT*"} |ft -AutoSize }