steampipe plugin install grendel-consulting/kolide

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,
url
from
kolide_package;

Find me which installers have had recent releases

select
id,
version
from
kolide_package
where
built_at > date_trunc('day', current_date) - interval '4 weeks';

Find me the installer url for macOS

select
url
from
kolide_package
where
id like 'darwin%';

Schema for kolide_package

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
built_attimestamp with time zoneWhen this installation package was built.
idtext=Unique identifier for this package.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextDisplay name for this event.
urltextURL that can be used to download this installation package. Requests to this url require the standard Authorization header needed for all Kolide API requests.
versiontextVersion of the Launcher agent that will be installed by this package.