Lists all the patches applied. Note: This does not include patches applied via MSI or downloaded from Windows Update (e.g. Service Packs).

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