Query Exchange

 View Only
  • 1.  Verifying Java version

    Posted Jul 25, 2019 12:45 AM
    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%';
    #ITHygiene
    #Community
    #Windows
    #VulnerabilityManagement


  • 2.  RE: Verifying Java version

    Broadcom Employee
    Posted Jul 26, 2019 01:24 AM

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



  • 3.  RE: Verifying Java version

    Posted Jul 26, 2019 02:10 AM

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



  • 4.  RE: Verifying Java version

    Broadcom Employee
    Posted Jul 30, 2019 03:54 PM


  • 5.  RE: Verifying Java version

    Posted Mar 31, 2022 08:32 PM

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



  • 6.  RE: Verifying Java version

    Broadcom Employee
    Posted Apr 01, 2022 03:12 PM

     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.



  • 7.  RE: Verifying Java version

    Posted Oct 19, 2023 08:13 AM

    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



  • 8.  RE: Verifying Java version

    Broadcom Employee
    Posted Oct 24, 2023 05:42 PM

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