Query: exec_docker_socket_not_mounted_inside_containers

with hostname as (
  select
    btrim(stdout_output, E' \n\r\t') as host,
    _ctx ->> 'connection_name' as host_conn,
    _ctx
  from
    exec_command
  where
    command = 'hostname'
),

 command_output as (
   select
     stdout_output,
     _ctx ->> 'connection_name' as conn
   from
     exec_command
   where
     command = 'docker ps --quiet --all | xargs docker inspect --format ''{{ .Id }}: Volumes={{ .Mounts }}'' | grep docker.sock'
 )
 select
   host as resource,
   case
     when o.stdout_output = '' then 'ok'
     else 'alarm'
   end as status,
   case
     when o.stdout_output = '' then host || ' Docker socket is not mounted inside any containers.'
     else host || ' Docker socket is mounted inside ' || (btrim(o.stdout_output, E' \n\r\t')) || '.'
   end as reason
   , h._ctx ->> 'connection_name' as connection_name
 from
   hostname as h,
   command_output as o
 where
   h.host_conn = o.conn;