Attention
Zercurity has been acquired by JumpCloud.
This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.
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) |
is_hidden | INTEGER | IsHidden attribute set in OpenDirectory |
Query examples¶
select * from users where uid = 1000
select * from users where username = 'root'
select count(*) from users u, user_groups ug where u.uid = ug.uid