turbot/gcp_insights

Query: kubernetes_cluster_auto_repair_status

Usage

powerpipe query gcp_insights.query.kubernetes_cluster_auto_repair_status

Steampipe Tables

SQL

select
status,
count(*)
from (
select name,
case when np -> 'management' -> 'autoRepair' = 'true' then
'enabled'
else
'disabled'
end status
from
gcp_kubernetes_cluster,
jsonb_array_elements(node_pools) as np) as c
group by
status
order by
status;

Dashboards

The query is used in the dashboards: