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’
Month: May 2011
Did you miss MMS this year? Well here is you change to see the highlight! (aka Put your head in the cloud) When: Friday, May 6 Where: Microsoft Canada Headquarters in Mississauga, Ontario Registration Details: http://www.microsoft.com/canada/events/event_details.aspx?event_id=1032484234