search cancel

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

book

Article ID: 112114

calendar_today

Updated On:

Products

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

Issue/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.

Environment

Release: UASMGT60000-1402-Asset Management
Component:

Resolution


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 
 

<Please see attached file for image>

User-added image

Attachments

1558697039599000112114_sktwi1f5rjvs16isg.jpeg get_app