Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
software_update
The software_update
table displays the number of updates available from Apple's Software Update service on a Mac.
Column | Type | Description |
---|---|---|
software_update_required | integer | A value of 0 means no updates are available. Any other integer represents the number of updates available. |
Basic query:
SELECT * FROM software_update;
This table is not a core osquery table. It is included as part of Fleet's agent (fleetd).
Available updates on a Mac can be displayed in the macOS Graphical User Interface (GUI) by clicking on the Apple menu and then selecting “System Settings”. In the System Settings.app, click General > Software Update.
Apple Software Updates can also be listed in Terminal with the following command:
softwareupdate --list --verbose