turbot/steampipe-mod-gcp-insights

Query: compute_instance_deletion_protection

Usage

powerpipe query gcp_insights.query.compute_instance_deletion_protection

Steampipe Tables

SQL

select
'Deletion Protection' as label,
case
when deletion_protection then 'Enabled'
else 'Disabled'
end as value,
case
when deletion_protection then 'ok'
else 'alert'
end as type
from
gcp_compute_instance
where
id = (split_part($1, '/', 1)) :: bigint
and project = split_part($1, '/', 2);

Dashboards

The query is used in the dashboards: