Query: List EC2 instances with failed compliance status

Description

Determine the areas in which EC2 instances have failed compliance checks. This is useful for identifying potential security risks and rectifying them to maintain the integrity of your AWS environment.

Query

Tables used in this query:

• aws_securityhub_finding

SQL