List for all team sites for a specific user

Question

I am looking for the possibility to display all the team sites a user is member of in the my site for the user.Also the possibility for the admin to get the same information about different user.

Is it possible in SharePoint 2010 entreprise edition? if yes could you please point me in the right direction?

Answer 1

If you have EnterpriseSearch set up, it already has that information for you, so you can query that with very good performance.

http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/ff828c3f-9f35-4d71-9870-156625d1f81b

Answer 2

You can use powershell to view list of all sites within a site collection user has access to.

SCRIPT

$user = "YOUR DOMAIN\YOUR USER" $site = $gc | Get-SPSite YOURSITECOLLECTIONURL $site | Get-SPWeb -Limit All | Get-SPUserEffectivePermissions $user | Out-GridView -Title "Web Permissions for $user"

Source: http://sp2010userperm.codeplex.com/

Answer 3

Its already been asked i think? here is the code snippit and url :)

using(SPSite site = new SPSite("http://example/site/")) 
{ 
    using (SPWeb web = site.OpenWeb()) 
    { 
        SPWebCollection webCollection = web.GetSubwebsForCurrentUser(); 
    } 
} 

http://stackoverflow.com/questions/1205050/how-to-retrieve-the-list-of-sharepoint-sites-user-has-access-to-from-a-window