ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 112114


Updated On:


CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager


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.


Release: UASMGT60000-1402-Asset Management


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

SELECT h.label,, 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 ( like '%java%' or like '%j2se%' or like '%jdk%') and s.software_type_id=3

<Please see attached file for image>

User-added image


1558697039599000112114_sktwi1f5rjvs16isg.jpeg get_app