SCCM report display computers with IPaddress based on Application/software

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 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

2 Responses to "SCCM report display computers with IPaddress based on Application/software"

  1. Hi Eswar,

    This is srinivas from HYD.

    I need to get one report from SCCM for oracle installed machines with versions like Enterprise or standard.
    we are getting reports but not sure with versions please help me out.

    Reply
    1. Identify computer which has Oracle app installed and go to Resource Explorer from collection of that computer and look at add and remove programs if the version is displayed there.
      If you see the version avilable,it would be easy to create report for Version. If you dont see the version from add and remove programs,then you may have to try with exe file (software inventory).
      try the first Idea and see how it works.

      Reply

Post Comment