SCCM report computers with lower version applications installed
Posted by Eswar Koneti on May 24th, 2012
Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/7b4d3810-a262-4c63-8dd6-7cc906b85941
select sys.name0,sys.AD_Site_Name0,FCM.SiteCode,ARP.DisplayName0,ARP.Version0,ARP.InstallDate0 from V_R_system sys
inner join v_Add_Remove_Programs ARP on arp.resourceID=sys.ResourceID
inner join v_FullCollectionMembership FCM on FCM.ResourceID=sys.ResourceID
and arp.DisplayName0 like ‘%project reader%’ and ARP.Version0 < ’4%’
For collection ,follow the post here on http://eskonr.com/2012/05/sccm-collection-computers-with-lower-version-application/