Verifying Java version

[mjomha]

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%';

[jnelson]

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

[mjomha]

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

[nejwan]

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]

@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.