turbot/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: