turbot/aws_insights

Query: ec2_network_interface_status

Usage

powerpipe query aws_insights.query.ec2_network_interface_status

SQL

select
'Status' as label,
case when status = 'in-use' then 'In Use' else initcap(status) end as value,
case when status = 'available' then 'alert' else 'ok' end as type
from
aws_ec2_network_interface
where
network_interface_id = $1

Dashboards

The query is used in the dashboards: