Report on Server/Computers that has Java installed

[jparman]

Hi,

We want to have a report showing the following:

All machines that have oracle java installed

• including:
• machine name
• Software display name
• machine processor count
• machine core count
• if machine is virtual yes/no
• if the machine is virtual also include the host machines processor count and core count

I am trying to report on the table cmdb_sam_sw_install for the java installations, filter on: publisher = oracle and product = java. I can see where Java is installed, however my problem is, when its installed in a Virtual Machine, I also want to get the host machine on my list. 

Report list contains the following:

1. computers that has java installed

2. virtual machines that has java installed

3. host server of the virtual machines (the host server of #2)

Report columns:

• machine name
• Software Display name
• CPU count
• core count
• is virtual

Can anyone please help? 

Thanks in advance!

[Engelica Adalia]

@jparman From the Software Installations table [cmdb_sam_sw_install], you can get the other details by dot walking the "Installed on" (machine name), Installed on.CPU count, Installed on.CPU core count, Installed on.Class (this is the only option I can think of that will show you if it's virtual or not). If you want to get the host information, I suggest to pull those details separately from the CI Relationship table [cmdb_rel_ci] which can show you the Parent and Child relationship (Runs on/Depends on). 

[Ashupakasma]

@jparman , I hope so this will help

[Andrew_TND]

Hi @jparman 

They can also be installed under cmdb_software_instance which also shows which machine they’re installed on, from there you can narrow down the results by dot walking to the asset record.

Please mark as helpful or if it’s resolved the issue, CORRECT!