Description: Information on Docker container ports.
What The Data Shows: Lists all the open ports for a container, and includes the name of the container.
SQL:
SELECT dc.name,substr(dcp.id,0,5) AS 'First 5 FROM ID', type,port,host_ip,host_port
FROM docker_container_ports AS dcp
JOIN docker_containers AS dc
ON dc.id = dcp.id;
