turbot/azure_insights

Query: kubernetes_cluster_agent_pools

Usage

powerpipe query azure_insights.query.kubernetes_cluster_agent_pools

Steampipe Tables

SQL

select
p ->> 'name' as "Name",
p ->> 'count' as "Node Count",
p ->> 'enableAutoScaling' as "Autoscaling Enabled",
p ->> 'enableNodePublicIP' as "Is Public",
p ->> 'osDiskSizeGB' as "OS Disk Size (GB)",
p ->> 'osDiskType' as "OS Disk Type",
p ->> 'osType' as "OS Type",
p ->> 'vmSize' as "VM Size"
from
azure_kubernetes_cluster c,
jsonb_array_elements(c.agent_pool_profiles) p
where
lower(id) = $1
order by
p ->> 'name';

Dashboards

The query is used in the dashboards: