-- Retrieves the command history, per user, by parsing the shell history files.
--
-- tags: postmortem
-- platform: posix
SELECT
*
FROM
users
JOIN shell_history USING (uid);