Query to list all the collections in which a machine is a member of

select a.netbios_name0,a.resourceid,a.Client0,a.Creation_date0,a.Obsolete0,a.Active0,b.CollectionID,c.Name,b.SiteCode
from v_r_system a
inner join v_FullCollectionMembership b on a.resourceid=b.resourceid
inner join v_collection c on b.Collectionid=c.Collectionid
where a.Netbios_Name0 like ''
Order by c.Name

Description:

This query lists all the collection Names in which a given machine is member of.