Queries in Kolide

The kolide plugin includes 35 queries:

Name	Description	Queries
kolide_admin_user	Users with access to the Kolide dashboard.	3
kolide_audit_log	Tracked events occurring in the Kolide web console.	2
kolide_auth_log	Authentication events occurring when a user tries to sign into an App protected by Kolide Device Trust.	2
kolide_check	Checks that Kolide runs on a device on a regular cadence, which are tests that typically produces a passing or failing result.	3
kolide_deprovisioned_person	Anyone who has been removed from Kolide via SCIM.	3
kolide_device	Devices enrolled and monitored by Kolide.	4
kolide_device_group	Group of devices, created in the UI or API	2
kolide_device_group_device	Member devices within a device group.	1
kolide_device_open_issue	Unresolved and non-exempt issues created when a specific device fails a check; some checks, when they fail, will produce multiple Issues, each with a unique primary_key_value.	2
kolide_exemption_request	Created when when a user desires to permanently ignore a specific issue or set of issues on a single device. Exemption requests are created by users and can be approved or denied by admins.	2
kolide_issue	Issues created when a device fails a check; some checks, when they fail, will produce multiple Issues, each with a unique primary_key_value.	4
kolide_package	Installation packages for Kolide Launcher agent for each major operating system.	2
kolide_person	People within your organisation, who may not necessarily have access to the Kolide dashboard (see kolide_admin_user). Devices may be registered to a person	2
kolide_person_open_issue	Unresolved and non-exempt issues created when a device owned by a specific person fails a check; some checks, when they fail, will produce multiple Issues, each with a unique primary_key_value.	1
kolide_registration_request	Created when someone requests admin approval to register a device with Kolide. Registration requests can be approved or denied by admins	2