turbot/aws_insights

Query: ec2_network_interface_attachment_status

Usage

powerpipe query aws_insights.query.ec2_network_interface_attachment_status

SQL

select
'Attachment Status' as label,
case
when attachment_status = 'attached' then 'Attached'
else 'Detached'
end as value,
case
when attachment_status = 'attached' then 'ok'
else 'alert'
end as type
from
aws_ec2_network_interface
where
network_interface_id = $1

Dashboards

The query is used in the dashboards: