Query: Count resources with failed compliance status

Description

Determine areas in your AWS environment where resources have failed compliance checks. This allows you to identify potential security risks and take corrective action.

Query

Tables used in this query:

• aws_securityhub_finding

SQL