kolide_device_group.md

Table: kolide_device_group

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

Examples

Basic info

select
  id,
  name
from
  kolide_device_group;

Find any empty of unused device groups

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

Find any newly created device groups

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