The VMware Carbon Black Tech Zone is live! Checkout this great resource: Mastering Carbon Black Audit & Remediation.

Verifying Java version

Description: Finds all installed version of java on a machine, useful as we always want to have Java up to date as Java vulnerabilities are alot especially outdated versions
What The Data Shows: Provides a list of all installed versions of Java on a machine.
SELECT name, install_date, install_location, version
FROM programs
WHERE name like '%javaw%';
Tags (1)
7 Comments
jnelson
Carbon Black Employee
Status changed to: Under Review

@mjomha you are missing the %s around javaw. ;-)

mjomha
Contributor

Thanks for noticing, my bad I should copy paste my query instead of typing it manually 🙂

jnelson
Carbon Black Employee
Status changed to: Approved
 
nejwan
New Contributor III

Hi Everyone,

What is the correct version of this query? can you write?

SELECT name, install_date, install_location, version
FROM programs
WHERE name like '%javaw%';

jnelson
Carbon Black Employee

@nejwan this query just returns all the current versions of Java installed on your endpoints. There is no logic in it to determine if it is up to date. A query like this could be written, but it would require constant up dating as Java gets updated.

syahmisyahir
New Contributor II

Hi all,

I have run a similar query on a Windows 10 device. But the result shows Not_Matched. It did work after I removed 'w' from '%javaw%'.

Thank you

jnelson
Carbon Black Employee

@syahmisyahir I am glad you were able to make it work for you.