turbot/aws_insights

Query: ec2_gateway_load_balancer_logging_enabled

Usage

powerpipe query aws_insights.query.ec2_gateway_load_balancer_logging_enabled

SQL

select
'Logging' as label,
case when lb ->> 'Value' = 'false' then 'Disabled' else 'Enabled' end as value,
case when lb ->> 'Value' = 'false' then 'alert' else 'ok' end as type
from
aws_ec2_gateway_load_balancer
cross join jsonb_array_elements(load_balancer_attributes) as lb
where
lb ->> 'Key' = 'access_logs.s3.enabled'
and aws_ec2_gateway_load_balancer.arn = $1;