All we really care about is the Collection ID, Name and the Comment section. We could add more but this is a quick report to help us find the machine.
select
C.CollectionID,
C.Name,
C.Comment
from
dbo.v_Collection C
join dbo.v_FullCollectionMembership FCM on C.CollectionID = FCM.CollectionID
Where
FCM.Name = @PC
When the report runs you will simply type in the machine name and click Run Report.
