turbot/aws_insights

Query: vpc_eip_association_details

Usage

powerpipe query aws_insights.query.vpc_eip_association_details

SQL

select
association_id as "Association ID",
e.instance_id as "Instance ID",
i.arn as "Instance ARN",
network_interface_id as "Network Interface ID"
from
aws_vpc_eip as e
left join aws_ec2_instance as i on i.instance_id = e.instance_id
where
e.arn = $1;

Dashboards

The query is used in the dashboards: