Vitals

Fleet’s built-in queries for collecting and storing important device information.

Apple

Linux

Windows Windows

ChromeOS

Battery Disk encryption Disk space Google Chrome profiles MDM MDM configuration profiles MDM Disk encryption key file MDM Disk encryption key file lines Munki info Network interfaces Orbit information Operating system information Osquery flags Osquery information Scheduled osquery statistics Software Software codesign Software Firefox VScode extensions Uptime Users

Disk encryption Disk space Google Chrome profiles Network interfaces Orbit information Operating system information Osquery flags Osquery information Scheduled osquery statistics Software VScode extensions Uptime Users

Battery Disk encryption Disk space Google Chrome profiles MDM Network interfaces Orbit information Operating system information Operating system version Osquery flags Osquery information Scheduled osquery statistics VScode extensions Software System information Uptime Users Windows update history

ChromeOS profile user info Google Chrome profiles Network interfaces Operating system information Software Users

Windows update history

Retrieves the history of the update events on a Windows host.

Query PowerShellNEW BashNEW

SELECT 
  date, title
FROM windows_update_history
WHERE result_code = 'Succeeded';

$updateSession = New-Object -ComObject Microsoft.Update.Session
$updateSearcher = $updateSession.CreateUpdateSearcher()
$totalHistoryCount = $updateSearcher.GetTotalHistoryCount()
$updateHistory = $updateSearcher.QueryHistory(0, $totalHistoryCount)
$updateHistory | Where-Object { $_.ResultCode -eq 2 } | Format-Table Date, Title -AutoSize