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_person_registered_device

Lists the registered devices belonging to a specified person.

You will need to provide a valid person_id for all queries to this table.

Examples

Basic info

select
  name,
  hardware_model,
  serial
from
  kolide_person_registered_device
where
  person_id = '12345';

Schema for kolide_person_registered_device

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
auth_configuration_authentication_mode	text		Who can be authenticated with this device, one of 'only_registered_owner', 'only_registered_owner_or_group_members' or 'anyone'.
auth_configuration_device_id	text		Canonical identifier for this device, empty if it is not registered
auth_configuration_person_groups	jsonb		Description of the groups allowed to authenticate with this device.
auth_state	text		Authorisation status of the device, one of Good, Notified, Will Block or Blocked.
device_type	text	=, ~~	Platform type of the device, one of Mac, Windows, Linux, iOS or Android.
form_factor	text		Form factor of the device, one of Computer, Tablet or Phone.
hardware_model	text		Specific hardware model of the device.
hardware_uuid	text	=, ~~	Hardware UUID for the device.
id	text		Canonical identifier for the device.
last_authenticated_at	timestamp with time zone	=, >, <	When the device was last authenticated with Kolide.
name	text	=, ~~	Canonical human name for the device.
note	text	=, ~~	Notes provided by a Kolide administrator (in Markdown format).
operating_system	text		Operating system installed on the device.
person_id	text	=	Canonical identifier of the registered owner of the device.
product_image_url	text		URL of the device's product image.
registered_at	timestamp with time zone	=, >, <	When the device was registered to its current owner.
registered_owner_identifier	text		Canonical identifier for the registered owner of this device.
serial	text	=, ~~	Hardware serial for the device.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Display name for this resource.
will_block_at	timestamp with time zone	=, >, <	If the auth status is 'Will Block', this timestamp describes when the device will be blocked by a failing check.