steampipe plugin install grendel-consulting/kolide

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.


Basic info

person_id = '12345';

Schema for kolide_person_registered_device

_ctxjsonbSteampipe context in JSON form.
auth_configuration_authentication_modetextWho can be authenticated with this device, one of 'only_registered_owner', 'only_registered_owner_or_group_members' or 'anyone'.
auth_configuration_device_idtextCanonical identifier for this device, empty if it is not registered
auth_configuration_person_groupsjsonbDescription of the groups allowed to authenticate with this device.
auth_statetextAuthorisation status of the device, one of Good, Notified, Will Block or Blocked.
device_typetext=, ~~Platform type of the device, one of Mac, Windows, Linux, iOS or Android.
form_factortextForm factor of the device, one of Computer, Tablet or Phone.
hardware_modeltextSpecific hardware model of the device.
hardware_uuidtext=, ~~Hardware UUID for the device.
idtextCanonical identifier for the device.
last_authenticated_attimestamp with time zone=, >, <When the device was last authenticated with Kolide.
nametext=, ~~Canonical human name for the device.
notetext=, ~~Notes provided by a Kolide administrator (in Markdown format).
operating_systemtextOperating system installed on the device.
person_idtext=Canonical identifier of the registered owner of the device.
product_image_urltextURL of the device's product image.
registered_attimestamp with time zone=, >, <When the device was registered to its current owner.
registered_owner_identifiertextCanonical identifier for the registered owner of this device.
serialtext=, ~~Hardware serial for the device.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextDisplay name for this resource.
will_block_attimestamp with time zone=, >, <If the auth status is 'Will Block', this timestamp describes when the device will be blocked by a failing check.