turbot/aws_insights

Query: vpc_eips_for_ec2_instance

Usage

powerpipe query aws_insights.query.vpc_eips_for_ec2_instance

SQL

select
e.arn as eip_arn
from
aws_vpc_eip as e,
aws_ec2_instance as i
where
e.instance_id = i.instance_id
and i.arn = $1;