Query: List resources with a failed compliance status for CIS AWS foundations benchmark

Description

Discover the segments that have failed to comply with the CIS AWS foundations benchmark. This allows you to identify and rectify areas in your AWS resources that are not adhering to the recommended security controls, thereby enhancing your overall security posture.

Query

Tables used in this query:

• aws_securityhub_finding

SQL