steampipe plugin install grendel-consulting/kolidesteampipe plugin install grendel-consulting/kolide

Table: kolide_device_group

Lists the groups of devices within your organisation, created by you.

Examples

select
  id,
  name
from
  kolide_device_group;

select
  id,
  name
from
  kolide_device_group;
where
  member_count = 0;

select
  id,
  name
from
  kolide_device_group;
where
  created_at > date_trunc('day', current_date) - interval '1 week';

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone	=, >, <	When this group record was created.
description	text	=, ~~	Longer-form description about this device group.
id	text	=	Canonical identifier for this group.
member_count	bigint		Number of member devices in this group.
name	text	=, ~~	Human-readable name for this group.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Display name for this group.