Computers with specific application installed with IPaddress. Additional reports for Add and remove programs are available from http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ SELECT  a.Name0,b.IPAddress0,c.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS c, v_R_System a, v_GS_NETWORK_ADAPTER_CONFIGUR b WHERE a.ResourceID = b.ResourceID and a.ResourceID=c.ResourceID and b.IPEnabled0='1' and b.ipaddress0 !='0.0.0.0' AND c.DisplayName0 like '%Adobe acrobat%' GROUP BY a.Name0, c.DisplayName0, b.IPAddress0   ORDER BY a.name0 If there are…