user_ssh_keys

Returns the private keys in the users ~/.ssh directory and whether or not they are encrypted.

Table schema

Name Type Description
uid BIGINT The local user that owns the key file
path TEXT Path to key file
encrypted INTEGER 1 if key is encrypted, 0 otherwise

Query examples

select * from users join user_ssh_keys using (uid) where encrypted = 0