Query: List of gateway load balancer with state other than active

Description

Identify instances where gateway load balancers in AWS EC2 are not in an 'active' state. This is useful to pinpoint potential issues or disruptions in network traffic routing.

Query

Tables used in this query:

• aws_ec2_gateway_load_balancer

SQL