Built off the open source project Osquery
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;
Copyright © 2005-2023 Broadcom. All Rights Reserved. The term “Broadcom” refers to Broadcom Inc. and/or its subsidiaries.