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: