Tables

Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.

Apple

puppet_info

Information on the last Puppet run. This table uses data from the last_run_report that Puppet creates.

Column	Type	Description
cached_catalog_status	text	The status of Puppet catalogs cached on the system.
catalog_uuid	text	The UUID of the catalog downloaded by Puppet.
code_id	text	The `code_id` links the catalog with the compile-time version of file resources using the `puppet:///` URI.
configuration_version	text	The version of the Puppet configuration.
corrective_change	text	A corrective change is triggered when Puppet detects a discrepency between the current state and the expected state of a value.
environment	text	The environment name.
host	text	The host on which Puppet is used.
kind	text	Kind of Puppet run.
master_used	text	The Puppet server used.
noop	text	Indicates if Puppet was run in noop mode.
noop_pending	text	Items pending from a noop run.
puppet_version	text	The version of Puppet used during the last run.
report_format	text	The format the Puppet report was exported as.
status	text	The status of Puppet on this system.
time	text	The time of the last Puppet run.
transaction_completed	text	Indicates if the transaction completed or not.
transaction_uuid	text	The UUID of the transaction.