list_container_process

Column Type
host_identifier BLOB
name BLOB
host BLOB
process_name BLOB
pid BLOB
uid BLOB
start_time BLOB
state BLOB
state_description
query_uri TEXT

SQL DDL

CREATE VIEW list_container_process AS
SELECT 
host_identifier,
name,
host,
process_name,
pid,
uid,
start_time,
state,
CASE state
  WHEN 'R' THEN 'Running'
  WHEN 'S' THEN 'Sleeping'
  WHEN 'D' THEN 'Uninterruptible Sleep'
  WHEN 'Z' THEN 'Zombie'
  WHEN 'T' THEN 'Stopped'
  WHEN 't' THEN 'Tracing Stop'
  WHEN 'X' THEN 'Dead'
  WHEN 'x' THEN 'Dead'
  WHEN 'K' THEN 'Wakekill'
  WHEN 'W' THEN 'Waking'
  WHEN 'P' THEN 'Parked'
  WHEN 'I' THEN 'Idle'
  ELSE 'Unknown'
END AS state_description,
query_uri
FROM ur_transform_list_container_process
;