This query will check the installed version of Confluence and print the message IF the installed confluence version is PATCHED or NOT PATCHED.
SELECT DISTINCT
'Check Confluence Version to confirm Patch' Test,
CASE version
WHEN '6.13.23' THEN 'Patched'
WHEN '7.4.11' THEN 'Patched'
WHEN '7.11.6' THEN 'Patched'
WHEN '7.12.5' THEN 'Patched'
WHEN '7.13.0' THEN 'Patched'
ELSE 'NOT PATCHED - Upgrade to Latest Version - https://confluence.atlassian.com/doc/confluence-security-advisory-2021-08-25-1077906215.html'
END Result
FROM programs
WHERE name LIKE 'Confluence%'
For More info - community.sophos.com/.../cve202126084
This thread was automatically locked due to age.