Tables

Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.

Apple

Linux

Windows

ChromeOS

docker_container_ports

Docker container ports.

Column	Type	Description
host_ip	text	Host IP address on which public port is listening
host_port	integer	Host port
id	text	Container ID
port	integer	Port inside the container
type	text	Protocol (tcp, udp)

Example

Identify the ports exposed at the host level and see which containers they redirect traffic to.

SELECT dc.name, dp.type, dp.port, dp.host_ip, dp.host_port FROM docker_container_ports dp JOIN docker_containers dc ON dp.id=dc.id WHERE dp.host_port !='0';

Edit page