turbot/azure_insights

Query: kubernetes_cluster_disk_public_status

Usage

powerpipe query azure_insights.query.kubernetes_cluster_disk_public_status

SQL

select
access,
count(*)
from
(
select
case
when api_server_access_profile ->> 'authorizedIPRanges' is null
and api_server_access_profile ->> 'enablePrivateCluster' = 'false' then 'public'
else 'private'
end access
from
azure_kubernetes_cluster
) as s
group by
access
order by
access;

Dashboards

The query is used in the dashboards: