Ermittelt die Collections in denen ein Computer enthalten ist.
SELECT sd.Name0 AS ComputerName,
col.CollectionName,
col.SiteID
FROM dbo.CollectionMembers cm
INNER JOIN System_disc sd ON cm.MachineID = sd.ItemKey
INNER JOIN Collections col ON cm.SiteID = col.SiteID
WHERE -- hier die 5 SiteIDs eintragen, die dich interessieren
col.CollectionName LIKE ('%')
AND sd.Name0 IN ('D-W-ITCVM19')
ORDER BY col.CollectionName,
sd.Name0