Tuesday, November 15, 2016

Report to help find collections a machine is in

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.