Open_sockets
osquery
Retrieves all the open sockets per process 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 open sockets per process in the target system.
--
-- tags: postmortem
-- platform: posix
SELECT DISTINCT
pid,
family,
protocol,
local_address,
local_port,
remote_address,
remote_port,
path
FROM
process_open_sockets
WHERE
path <> ''
or remote_address <> '';tags: SStagSS