turbot/steampipe-mod-aws-compliance

Control: ELB classic load balancers should have at least one registered instance

Description

This control checks whether an ELB classic load balancer has registered instances. The control fails if an ELB classic load balancer has zero instances registered.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.elb_classic_lb_no_registered_instance

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.elb_classic_lb_no_registered_instance --share

SQL

This control uses a named query:

select
arn as resource,
case
when jsonb_array_length(instances) = 0 then 'alarm'
else 'ok'
end as status,
title || ' has ' || jsonb_array_length(instances) || ' instance(s) registered.' as reason
, region, account_id
from
aws_ec2_classic_load_balancer;

Tags