Attention
Zercurity has been acquired by JumpCloud.
This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.
patches¶
Lists all the patches applied. Note: This does not include patches applied via MSI or downloaded from Windows Update (e.g. Service Packs).
Platform support¶
Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: patches
- Windows
Table schema¶
Name | Type | Description |
---|---|---|
csname | TEXT | The name of the host the patch is installed on. |
hotfix_id | TEXT | The KB ID of the patch. |
caption | TEXT | Short description of the patch. |
description | TEXT | Fuller description of the patch. |
fix_comments | TEXT | Additional comments about the patch. |
installed_by | TEXT | The system context in which the patch as installed. |
install_date | TEXT | Indicates when the patch was installed. Lack of a value does not indicate that the patch was not installed. |
installed_on | TEXT | The date when the patch was installed. |
Query examples¶
select * from patches