turbot/aws_insights

Query: ec2_target_groups_for_ec2_instance

Usage

powerpipe query aws_insights.query.ec2_target_groups_for_ec2_instance

SQL

select
target.target_group_arn
from
aws_ec2_instance as i,
aws_ec2_target_group as target,
jsonb_array_elements(target.target_health_descriptions) as health_descriptions
where
i.arn = $1
and health_descriptions -> 'Target' ->> 'Id' = i.instance_id;