Fleet logo
Menu An icon indicating that interacting with this button will open the navigation menu.
Fleet logo An 'X' icon indicating that this can be interacted with to close the navigation menu.
Solutions A small chevron
Device management

Device management

Remotely manage, and protect laptops and mobile devices.

Orchestration

Orchestration

Automate tasks across devices, from app installs to scripts.

Software management

Software management

Inventory, patch, and manage installed software.

GitOps

Infrastructure as code

See every change, undo any error, repeat every success.

Extend Fleet

Extend Fleet

Integrate your favorite tools with Fleet.

Customers Pricing
More A small chevron
Get a demo

Tables

Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.

macOS Apple

Linux Linux

Windows Windows

Chrome ChromeOS

groups

click to open the table of contents
macOS logo Windows logo Linux logo

groups

Local system groups.

Column Type Description
comment text Remarks or comments associated with the group
Only available on Windows
gid bigint Unsigned int64 group ID
gid_signed bigint A signed int64 version of gid
group_sid text Unique group ID
Only available on Windows
groupname text Canonical local group name
is_hidden integer IsHidden attribute set in OpenDirectory
Only available on macOS
pid_with_namespace integer Pids that contain a namespace
Only available on Linux

Example

See all groups with the IsHidden OpenDirectory attribute:

SELECT * FROM groups WHERE is_hidden='1';

Collect the users that are members of the admin group:

SELECT * FROM groups JOIN user_groups USING (gid) JOIN users USING (uid) WHERE groupname='admin';

Notes

  • On Windows, gid and gid_signed are always the same
Edit page

Questions?

Ask us anything
{{table.title}} evented table