user_ssh_keys
=============

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

Platform support
----------------
Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. **Running a query against an unsupported platform will result in the following error:** ``no such table: user_ssh_keys``

- Linux
- Mac OSX

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
--------------

.. code-block:: sql

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