Fleet logo
Menu An icon indicating that interacting with this button will open the navigation menu.
Fleet logo An 'X' icon indicating that this can be interacted with to close the navigation menu.
Multi platform
Device management + MDM Orchestration + monitoring Software management + CVEs, usage, app library Integrations
Docs
Stories
News Ask around Meetups Schedule a demo Share your story COMPANY The handbook Testimonials
Pricing Try it yourself

Tables

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

macOS Apple

Linux Linux

Windows Windows

Chrome ChromeOS

puppet_state

click to open the table of contents
macOS logo Windows logo Linux logo

puppet​_state

State of every resource Puppet is managing. This table uses data from the last_run_report that Puppet creates.

Column Type Description
change_count text The count of changes to be performed.
changed text If change_count is above 0, this is true.
corrective_change text True if a change on the system caused unexpected changes between two Puppet runs.
evaluation_time text The amount of seconds it took to evaluate the resource.
failed text If Puppet failed to evaluate this resource, this column is true.
file text The file that contains the resource.
line text The line on which the resource is specified.
out_of_sync text If out_of_sync_count is above 0, this is true.
out_of_sync_count text The number of properties that are out of sync
resource text The resource and its title as Type[title].
resource_type text The resource type.
skipped text True if this resource was skipped.
title text The name of the resource.

Example

List resources that failed or took over a minute to evaluate.

SELECT * FROM puppet_state WHERE failed='true' OR evaluation_time|-'60';

Notes

This table is from the Mac Admins osquery extension.

Edit page

Questions?

Ask us anything
{{table.title}} evented table