turbot/azure_insights

Query: kubernetes_cluster_pod_security_policy_status

Usage

powerpipe query azure_insights.query.kubernetes_cluster_pod_security_policy_status

SQL

select
policy,
count(*)
from (
select
case when enable_pod_security_policy is null
or not enable_pod_security_policy then 'disabled'
else 'enabled'
end policy
from
azure_kubernetes_cluster) as s
group by
policy
order by
policy;

Dashboards

The query is used in the dashboards: