Just had a conversation with a couple instructors in the speaker room here at the BPUK Conference. What is the most efficient way to get a list of sites a user has permissions to. Search of course, it does the security trimming for you and it has a master list of all sites within SharePoint (assuming you crawl SharePoint sites).
The trick here is to format a Keyword query search with the proper properties, in this case itâ€™s the contentclass property with a value of sts_site. Optionally we might want to add additional constructs which would limit the scope of the search such as using the PATH property and using suffix matching.
So here is a query logged on as the Administratorâ€¦
And here is another logged on as Dan Bacon Jrâ€¦