Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
windows_update_history
Provides the history of the windows update events.
Column | Type | Description |
---|---|---|
client_app_id | text | Identifier of the client application that processed an update |
date | bigint | Date and the time an update was applied |
description | text | Description of an update |
hresult | bigint | HRESULT value that is returned from the operation on an update |
operation | text | Operation on an update |
result_code | text | Result of an operation on an update |
server_selection | text | Value that indicates which server provided an update |
service_id | text | Service identifier of an update service that is not a Windows update |
support_url | text | Hyperlink to the language-specific support information for an update |
title | text | Title of an update |
update_id | text | Revision-independent identifier of an update |
update_revision | bigint | Revision number of an update |
select * from windows_update_history