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_exemption_request

Lists the exemption requests made when a user desires to permanently ignore a specific issue or set of issues on a single device. These can be approved or denied by admins.

Examples

Basic info

select
  id,
  status,
  requested_at,
  requester_message,
  requester_id,
  device_id,
  issues
from
  kolide_exemption_request;

List all unresolved requests

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

List all recent requests

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

Schema for kolide_exemption_request

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
denial_explanation	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 exemption has not been denied.
device_id	text		Canonical identifier for the device the person is trying to register.
id	text	=	Canonical identifier for this exemption request.
internal_explanation	text		Any internal explanation the admin provided when approving or denying this request, for internal documentation. It is not shown to the requester. It will be blank if the exemption has not been denied.
issues	jsonb
requested_at	timestamp with time zone	=, >, <	When this exemption was requested.
requester_id	text		Canonical identifier for the person who requested this exemption.
requester_message	text	=, ~~	Any message the person provided when asking for this exemption.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text	=, ~~	Current status of this exemption request; one of: open, withdrawn, approved or denied
title	text		Display name for this exemption request.