SCCM SQL Query : to find out collection memberships of a machine

select v_FullCollectionMembership.CollectionID, v_Collection.Name

from v_FullCollectionMembership

join v_Collection ON v_FullCollectionMembership.CollectionID = v_Collection.CollectionID

where  v_FullCollectionMembership.Name = 'machinename'