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