Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
load_average
Displays information about the system wide load averages.
Column | Type | Description |
---|---|---|
average | text | Load average over the specified period. |
period | text | Period over which the average is calculated. |
Find computers with a load average of 3.5 or higher over the last 15 minutes.
SELECT average from load_average WHERE period='15m' AND average|-=3.5;