Query: ELB application, network, and gateway load balancers should span multiple availability zones

Description

This control checks whether an Elastic Load Balancer V2 (Application, Network, or Gateway Load Balancer) has registered instances from multiple Availability Zones. The control fails if an Elastic Load Balancer V2 has instances registered in fewer than two Availability Zones.

Query

Tables used in this query:

• aws_ec2_application_load_balancer
• aws_ec2_gateway_load_balancer
• aws_ec2_network_load_balancer

Controls using this query:

• 13 Application, Network, and Gateway Load Balancers should span multiple Availability Zones
• ELB application, network, and gateway load balancers should span multiple availability zones

SQL