Local user accounts (including domain accounts that have logged on locally (Windows)).
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
- Mac OSX
- Free BSD
|gid||BIGINT||Group ID (unsigned)|
|uid_signed||BIGINT||User ID as int64 signed (Apple)|
|gid_signed||BIGINT||Default group ID as int64 signed (Apple)|
|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|
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