We have seen similar requirements many times. How do i find all the sites a particular user is a member of? One way is to write a SQL query with joins on the alf_ tables in the database. But Alfresco advises against hitting the data base directly. Instead we can use webscripts that are provided by Alfresco to get the information we need quickly.