turbot/aws_insights

Query: ec2_network_interface_delete_on_termination

Usage

powerpipe query aws_insights.query.ec2_network_interface_delete_on_termination

SQL

select
'Delete on Instance Terminate' as label,
case
when interface_type = 'interface' then case
when delete_on_instance_termination then 'Enabled'
else 'Disabled'
end
else 'Not Applicable'
end as value,
case
when interface_type = 'interface' then case
when delete_on_instance_termination then 'ok'
else 'alert'
end
else ''
end as type
from
aws_ec2_network_interface
where
network_interface_id = $1;

Dashboards

The query is used in the dashboards: