SELECT DISTINCT
FCM.Name,
OPSYS.Caption0,
OPSYS.Version0,
ARP.Displayname0
FROM
dbo.v_FullCollectionMembership FCM
JOIN dbo.v_GS_OPERATING_SYSTEM OPSYS on FCM.ResourceID = OPSYS.ResourceID
join dbo.v_GS_SYSTEM SYS on SYS.ResourceID = FCM.ResourceID
Join dbo.v_Add_Remove_Programs ARP on ARP.ResourceID = FCM.ResourceID
WHERE
SYS.SystemRole0 = ‘Server’
and ARP.Displayname0 in (‘Microsoft SQL Server 2005′,’Microsoft SQL Server 2000’)