Control: Replication Controller containers ports should not have host port specified
Description
This check ensures that the container ports in the Replication Controller do not have host port specified.
Usage
Run the control in your terminal:
powerpipe control run kubernetes_compliance.control.replication_controller_container_host_port_not_specifiedSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run kubernetes_compliance.control.replication_controller_container_host_port_not_specified --shareSQL
This control uses a named query:
select  coalesce(uid, concat(path, ':', start_line)) as resource,  case    when (c -> 'ports') is null then 'ok'    when (c->>'ports') like '%hostPort%' then 'alarm'    else 'ok'  end as status,  case    when (c -> 'ports') is null then c ->> 'name' || ' ports not defined.'    when (c->>'ports') like '%hostPort%' then c ->> 'name' || ' host port specified.'    else c ->> 'name' || ' host port not specified.'  end as reason,  name as replication_controller_name    , coalesce(context_name, '') as context_name, namespace, source_type, coalesce(path || ':' || start_line || '-' || end_line, '') as pathfrom  kubernetes_replication_controller,  jsonb_array_elements(template -> 'spec' -> 'containers') as c;