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