turbot/aws_insights

Query: ec2_network_interface_public_ip

Usage

powerpipe query aws_insights.query.ec2_network_interface_public_ip

SQL

select
'Public IP' as label,
case
when association_public_ip is null then 'None'
else host(association_public_ip)
end as value
from
aws_ec2_network_interface
where
network_interface_id = $1

Dashboards

The query is used in the dashboards: