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

kolide_admin_user kolide_audit_log kolide_check kolide_deprovisioned_person kolide_device kolide_device_group kolide_device_group_device kolide_device_open_issue kolide_issue kolide_package kolide_person kolide_person_group kolide_person_open_issue kolide_person_registered_device

Table: kolide_admin_user

Lists the users with access to the Kolide dashboard. Depending on your organization's restrictions, they are able to view and manage checks, devices, users, and other settings.

Examples

Basic info

select
  first_name,
  last_name,
  email,
  access,
  created_at
from
  kolide_admin_user;

List all Kolide super admins

select
  email
from
  kolide_admin_user
where
  access = 'full';

List all admins external to my company

select
  first_name,
  last_name,
  email,
  access,
  created_at
from
  kolide_admin_user
where
  email not like '%@grendel-consulting.com';

List all admins created recently

select
  first_name,
  last_name,
  email,
  access,
  created_at
from
  kolide_admin_user
where
  created_at > date_trunc('day', current_date) - interval '1 week';

Schema for kolide_admin_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
access	text		Access level granted to this admin user, one of full, limited or billing.
created_at	timestamp with time zone	=, >, <	When this admin user account was created.
email	text	=, ~~	Email address for this admin user.
first_name	text	=, ~~	Given or first name for this admin user.
id	text	=	Canonical identifier for this admin user.
last_name	text	=, ~~	Familial or last name for this admin user.
restrictions	jsonb		Feature restrictions applied to this user; this list will be empty unless the user has an access level of 'limited'.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Display name for this admin user.