v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Hub

Plugins Mods Docs Home

Plugins

grendel-consulting/kolide

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

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

Table: kolide_registration_request

Lists the registration requests made when attempting to register a device with Kolide. These can be approved or denied by admins.

Examples

Basic info

select
  id,
  status,
  requested_at,
  requester_message,
  requester_id,
  device_id
from
  kolide_registration_request;

List all unresolved requests

select
  id,
  status,
  requested_at,
  requester_message,
  requester_id,
  device_id
from
  kolide_registration_request
where
  status != 'approved';

List all recent requests

select
  id,
  status,
  requested_at,
  requester_message,
  requester_id,
  device_id
from
  kolide_registration_request
where
  requested_at > date_trunc('day', current_date) - interval '4 weeks';

Schema for kolide_registration_request

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
device_id	text		Canonical identifier for the device the person is trying to register.
end_user_denial_note	text		Any explanation the admin provided for the requester when denying this request, for internal documentation. It is meant to be shown to the requester. It will be blank if the registration has not been denied.
id	text	=	Canonical identifier for this registration request.
internal_denial_note	text		Any internal explanation the admin provided when denying this request, for internal documentation. It is not shown to the requester. It will be blank if the registration has not been denied.
requested_at	timestamp with time zone	=, >, <	When this registration approval was requested.
requester_id	text		Canonical identifier for the person who requested this registration.
requester_message	text	=, ~~	Any message the person provided when requesting approval for this registration.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text	=, ~~	Current status of this registration request; one of: pending, approved or denied
title	text		Display name for this registration request.