turbot/aws_insights

Query: ec2_network_interface_association_details

Usage

powerpipe query aws_insights.query.ec2_network_interface_association_details

SQL

select
eni.association_allocation_id "Allocation ID",
eni.association_public_ip as "Public IP Address",
eni.association_carrier_ip as "Carrier IP",
eni.association_customer_owned_ip as "Customer Owned IP",
eni.association_id as "Association ID",
eni.association_ip_owner_id as "IP Owner ID",
eni.association_public_dns_name as "Public DNS Name",
eip_alloc.arn as "EIP Alloc ARN"
from
aws_ec2_network_interface eni
left join aws_vpc_eip eip_alloc on
eip_alloc.allocation_id = eni.association_allocation_id
and eip_alloc.association_id = eni.association_id
where
eni.network_interface_id = $1
and eni.association_allocation_id is not null;

Dashboards

The query is used in the dashboards: