Month – December 2011

64 Bit Office

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

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