Query: docker_container_root_filesystem_mounted

select
  id as resource,
  case
    when inspect -> 'HostConfig' ->> 'ReadonlyRootfs' = 'false' then 'alarm'
    else 'ok'
  end as status,
  case
    when inspect -> 'HostConfig' ->> 'ReadonlyRootfs' = 'false' then (names ->> 0) || ' root filesystem not mounted as read only.'
    else (names ->> 0) || ' root filesystem mounted as read only.'
  end as reason
  , _ctx ->> 'connection_name' as connection_name
from
  docker_container;