Client Automation - How to retrieve the installation PATH of all Java installations of all machines ?
Article ID: 112114
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:
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
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>
Attachments
Feedback
Yes
No
Powered by
