Control: ELB classic load balancers should span multiple availability zones
Description
This control checks whether a Classic Load Balancer has been configured to span multiple Availability Zones. The control fails if the Classic Load Balancer does not span multiple Availability Zones.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.elb_classic_lb_multiple_az_configuredSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.elb_classic_lb_multiple_az_configured --shareSQL
This control uses a named query:
select  arn as resource,  case    when jsonb_array_length(availability_zones) < 2 then 'alarm'    else 'ok'  end as status,  title || ' has ' || jsonb_array_length(availability_zones) || ' availability zone(s).' as reason    , region, account_idfrom  aws_ec2_classic_load_balancer;