osquery-defense-kit/incident_response/user_ssh_keys.sql

9 lines
116 B
SQL

-- Retrieves the ssh keys per user
--
-- tags: postmortem
SELECT
*
FROM
users
JOIN user_ssh_keys USING (uid);