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

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