Query to check for vulnerable versions of Google Chrome (CVE-2023-6345)

[DK]

Description: Edit: The query has been updated to report on specific versions of Chrome that are vulnerable. This allows you to determine specifically versions of Chrome that are vulnerable, and not those that have been patched. It also allows more versatility, allowing the query to be used again in the future by changing the version number. 

What The Data Shows: This is useful for determining if Chrome has updated itself to the latest version to make sure you are protected from vulnerabilities such as CVE-2023-6345. 

SQL: 

SELECT name,

       version,

       "YES" AS "vulnerable"

FROM programs

WHERE name = "Google Chrome"

    AND version < "119.0.6045.199";

[jnelson]

@DK why is the "LIMIT 1" necessary?