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’

Leave a Reply

Your email address will not be published. Required fields are marked *