Collections a machine belongs to

This question was posed in the newsgroup: “How can I find out what collections a machine belongs to?”

Here is the anwser:

SELECT Col.Name,
FCol.Name
FROM  v_Collection Col,
v_FullCollectionMembership FCol
WHERE  Col.CollectionID = FCol.CollectionID
AND FCol.Name=’ComputerName’