Query: List of flow logs whose logs delivery has failed

Description

Identify instances where the delivery of flow logs has failed in AWS Virtual Private Cloud (VPC). This can aid in diagnosing and rectifying issues related to log delivery, thereby ensuring seamless logging and monitoring.

Query

Tables used in this query:

• aws_vpc_flow_log

SQL