Select
Name0
From
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_FullCollectionMembership FCM on CS.ResourceID = FCM.ResourceID
Where
CS.ResourceId in (select ARP.ResourceId from dbo.v_Add_Remove_Programs ARP Where ARP.Displayname0 = 'Windows Server 2003 Service Pack 2')
and CS.ResourceId in (select ARP.ResourceId from dbo.v_Add_Remove_Programs ARP Where ARP.Displayname0 = 'McAfee VirusScan Enterprise')
and FCM.CollectionID = 'SMS00001'
http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/2ebeb8f8-13be-4934-8123-c1c9e8003b87
