September 22, 2014 — sanmansp
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’
Advertisements
