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

Leave a Reply

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