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 -------------- .. code-block:: sql select * from patches