Query: Get CVEs for all images pushed in the last 24 hours

Description

Explore potential vulnerabilities in your system by identifying Common Vulnerabilities and Exposures (CVEs) in all images that have been pushed in the last 24 hours. This is particularly useful for maintaining system security and identifying areas that may need immediate attention or updates.

Query

Tables used in this query:

• aws_ecr_image_scan_finding

SQL