turbot/kubernetes_insights

Query: container_privileged_count

Usage

powerpipe query kubernetes_insights.query.container_privileged_count

Steampipe Tables

SQL

select
count(c ->> 'name') as value,
'Privileged' as label,
case count(c ->> 'name') when 0 then 'ok' else 'alert' end as type
from
kubernetes_pod,
jsonb_array_elements(containers) as c
where
c -> 'securityContext' ->> 'privileged' = 'true';

Dashboards

The query is used in the dashboards: