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/
WHERE a.ResourceID = b.ResourceID and
b.IPEnabled0='1' and b.ipaddress0 !='0.0.0.0'
AND c.DisplayName0 like '%Adobe acrobat%'
ORDER BY a.name0
If there are multiple computer entries,no worries bcz computer might have additional network connections which will have more than One IP which can be identified Via Resource Explorer—Hardware—>network adapter configuration