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