Report Two items from Add/Remove Program

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