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

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