turbot/kubernetes_insights

Query: container_immutable_root_filesystem_status

Usage

powerpipe query kubernetes_insights.query.container_immutable_root_filesystem_status

Steampipe Tables

SQL

select
case when c -> 'securityContext' ->> 'readOnlyRootFilesystem' = 'true' then 'used' else 'unused' end as status,
count(c)
from
kubernetes_pod,
jsonb_array_elements(containers) as c
group by
status;

Dashboards

The query is used in the dashboards: