Query: List findings with failed compliance status

Description

Determine the areas in which security findings have failed compliance checks. This is useful for identifying potential vulnerabilities and areas that require immediate attention in your AWS Security Hub.

Query

Tables used in this query:

• aws_securityhub_finding

SQL