Client Automation - How to retrieve the installation PATH of all Java installations of all machines ?

Document ID : KB000112114
Last Modified Date : 24/08/2018
Show Technical Document Details
Introduction:

To calculate license needs a report of all installation path of java on all computers is needed.
How to do this quicky ?

A solution is to create a ITCM Report which returns installation path of all detected software and then apply a filter to display only Java software.
But this report could be huge and take long time to be generated.
Instructions:

A solution is to use a SQL Query which could be executed in Microsoft SQL Server Management Studio :
 
use mdb

SELECT h.label, s.name, s.sw_version_label, d.install_path
FROM ca_discovered_hardware h
LEFT JOIN ca_discovered_software d ON d.asset_source_uuid=h.dis_hw_uuid
LEFT JOIN ca_software_def s ON d.sw_def_uuid=s.sw_def_uuid
WHERE (s.name like '%java%' or s.name like '%j2se%' or s.name like '%jdk%') and s.software_type_id=3
ORDER BY 1,2 
 
User-added image