Query: List images with failed scans

Description

Identify instances where image scans have failed in your AWS ECR repositories. This can help in diagnosing and rectifying issues related to image scanning, thereby improving the security and reliability of your container images.

Query

Tables used in this query:

• aws_ecr_repository

SQL