turbot/azure_insights

Query: kubernetes_cluster_input

Usage

powerpipe query azure_insights.query.kubernetes_cluster_input

SQL

select
c.title as label,
lower(c.id) as value,
json_build_object(
'Subscription',
s.display_name,
'Resource Group',
c.resource_group,
'Region',
c.region,
'ID',
c.id
) as tags
from
azure_kubernetes_cluster as c,
azure_subscription as s
where
lower(c.subscription_id) = lower(s.subscription_id)
order by
c.title;

Dashboards

The query is used in the dashboards: