turbot/gcp_insights

Query: kubernetes_cluster_auto_repair_disabled

Usage

powerpipe query gcp_insights.query.kubernetes_cluster_auto_repair_disabled

Steampipe Tables

SQL

select
case when np -> 'management' -> 'autoRepair' = 'true' then 'Enabled' else 'Disabled' end as value,
'Node Auto-Repair' as label,
case when np -> 'management' -> 'autoRepair' = 'true' then 'ok' else 'alert' end as type
from
gcp_kubernetes_cluster,
jsonb_array_elements(node_pools) as np
where
id = split_part($1, '/', 1)
and project = split_part($1, '/', 2);

Dashboards

The query is used in the dashboards: