SELECT CS.Name0, ARP64.DisplayName0, ARP64.Version0 FROM dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_ADD_REMOVE_PROGRAMS_64 ARP64 on CS.ResourceID = ARP64.ResourceID Where ARP64.DisplayName0 like ‘%office%’ In response to http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/498ffe87-9a3d-433f-9927-020fd4c3777b
Month: December 2011
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