independent
05/21/2025, 2:38 PMprocess_events and the osqueryd. We have configured:
"non_https_network_connection": {
"query":
"SELECT p.pid, p.path, pr.path AS parent_process, p.cmdline,
se.local_port, se.remote_port, se.local_address, se.remote_address FROM
socket_events AS se INNER JOIN process_events AS p ON p.pid = se.pid
LEFT JOIN process_events AS pr ON pr.pid = p.parent WHERE
.........<rest of query>';",
"interval": "60",
"description": "."
},
Now this work locally osqueryi
and presents all the events. The problem is when we run this pack with
the deamon only one event is returned every 60s, while you would suspect
all the events to be returned of the last 60s. Are we missing something
here. Is this an optimisation issue? happy to hear?
Best regards.