Description: List ports that are listening on all interfaces, along with the process to which they are attached.
What The Data Shows: Useful for auditing attack surface, IT Hygiene, or vulnerable software.
SELECT lp.address, lp.pid, lp.port, lp.protocol, p.name, p.path, p.cmdlineFROM listening_ports lpJOIN processes p ON lp.pid = p.pidWHERE lp.address = "0.0.0.0";
hey @cfogleman thank you for your submission! We will test your query and if it runs as expected we'll update your submission from Under Review to CB Approved.