Listening_ports
osquery
Retrieves all the listening ports in the target system.
Description
ODK (osquery-defense-kit) is unique in that the queries are designed to be used as part of a production detection & response pipeline. The detection queries are formulated to return zero rows during normal expected behavior, so that they may be configured to generate alerts when rows are returned.
Query
-- Retrieves all the listening ports in the target system.
--
-- tags: postmortem
-- platform: posix
SELECT
lp.*,
p.name AS p_name,
p.start_time AS p_time,
p.path AS p_path,
p.euid AS p_euid
FROM
listening_ports AS lp
LEFT JOIN processes p ON lp.pid = p.pid;tags: SStagSS