Month – May 2011

Server by Collection

select Distinct CS .Name0, CS .Domain0, OS .Caption0 From dbo .v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceID join dbo.v_GS_SYSTEM S on CS.ResourceID = S.ResourceID join dbo.v_FullCollectionMembership FCM on CS.ResourceID = FCM.ResourceID Where S .SystemRole0 = ‘Server’ and FCM.CollectionID = ‘SMS00001’