SELECT 
vc.CollectionID, 
vc.Name 
FROM v_collection vc
INNER JOIN v_FullCollectionMembership vfcm 
	ON vc.collectionid = vfcm.collectionid
INNER JOIN v_r_system vrsys 
	ON vfcm.Resourceid = vrsys.resourceid
INNER JOIN v_collecttosubcollect vctsc 
	ON vfcm.collectionid = vctsc.subcollectionid
WHERE 
vrsys.netbios_name0 = @compname
AND
(
vctsc.parentcollectionid = 'XXXXXXXX'  --Restricted
OR
vctsc.parentcollectionid = 'XXXXXXXX'  --UnRestricted
)
ORDER BY vc.Name