users
=====

Local user accounts (including domain accounts that have logged on locally (Windows)).

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: users``

- Windows
- Linux
- Mac OSX
- Free BSD

Table schema
------------

===========  ======  ===================================================================
Name         Type    Description                                                        
===========  ======  ===================================================================
uid          BIGINT  User ID                                                            
gid          BIGINT  Group ID (unsigned)                                                
uid_signed   BIGINT  User ID as int64 signed (Apple)                                    
gid_signed   BIGINT  Default group ID as int64 signed (Apple)                           
username     TEXT    Username                                                           
description  TEXT    Optional user description                                          
directory    TEXT    User's home directory                                              
shell        TEXT    User's configured default shell                                    
uuid         TEXT    User's UUID (Apple) or SID (Windows)                               
type         TEXT    Whether the account is roaming (domain), local, or a system profile
===========  ======  ===================================================================

Query examples
--------------

.. code-block:: sql

   select * from users where uid = 1000


.. code-block:: sql

   select * from users where username = 'root'


.. code-block:: sql

   select count(*) from users u, user_groups ug where u.uid = ug.uid