turbot/aws_compliance

Query: autoscaling_group_with_lb_use_health_check

Usage

powerpipe query aws_compliance.query.autoscaling_group_with_lb_use_health_check

SQL

select
autoscaling_group_arn as resource,
case
when load_balancer_names is null and target_group_arns is null then 'alarm'
when health_check_type != 'ELB' then 'alarm'
else 'ok'
end as status,
case
when load_balancer_names is null and target_group_arns is null then title || ' not associated with a load balancer.'
when health_check_type != 'ELB' then title || ' does not use ELB health check.'
else title || ' uses ELB health check.'
end as reason
, region, account_id
from
aws_ec2_autoscaling_group;

Controls

The query is being used by the following controls: