Iterate Site Collection Administrators across web app

Question

How can I find out all the sites where the user is a primary site collection administrator or a secondary site collection administrator.

We have around 200+ site collections and growing and hence looking to avoid a loop. For membership we are currently using "contentclass:sts_site" with SearchServiceApplicationProxy.

I guess I should have added more details to the above - Since I already have the code for the Search Application Proxy utilizing the object model, preferably I was looking towards a solution where I could still utilize Search Application Proxy to fetch all details in one go.

Answer 1

This should do what you you want

$user = "domian\username"
Get-SPSite | Where {$_.Owner.UserLogin -eq $user -or $_.SecondaryContact.UserLogin -eq $user}

Answer 2

I don't have a box handy to give you exact code, but you could use powershell to get all SPSites within a web application, and filter by a given username (Owner is the property you want from each SPSite object).