kolide_admin_userkolide_audit_logkolide_auth_logkolide_checkkolide_deprovisioned_personkolide_devicekolide_device_groupkolide_device_group_devicekolide_device_open_issuekolide_exemption_requestkolide_issuekolide_packagekolide_personkolide_person_groupkolide_person_open_issuekolide_person_registered_devicekolide_registration_request
Table: kolide_package
Lists the published installation packages for the Kolide Launcher agent for each major operating system.
Examples
Basic info
select id, built_at, version, urlfrom kolide_package;
Find me which installers have had recent releases
select id, versionfrom kolide_packagewhere built_at > date_trunc('day', current_date) - interval '4 weeks';
Find me the installer url for macOS
select urlfrom kolide_packagewhere id like 'darwin%';
Schema for kolide_package
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
built_at | timestamp with time zone | When this installation package was built. | |
id | text | = | Unique identifier for this package. |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
title | text | Display name for this event. | |
url | text | URL that can be used to download this installation package. Requests to this url require the standard Authorization header needed for all Kolide API requests. | |
version | text | Version of the Launcher agent that will be installed by this package. |