Search for Unapproved Windows Patches
Use the search tokens below to search for Windows patches. Looking for help with writing your query? click here
patch.appFamilypatch.appFamily
Use values within quotes or backticks to find patches belonging to certain applications.
Examples
Find patches for SQL Server
patch.appFamily: SQL Server
Find patches that contain parts of the application name
patch.appFamily: "SQL Server 2017 Express Edition"
Find patches that match exact value
patch.appFamily: `SQL Server 2017`
patch.architecturepatch.architecture
Use a text value ##### to find patches applied to a certain architecture (x86, x64).
Example
Find patches for x64
patch.architecture: x64
Use a text value ##### to find patches with certain bulletin name.
Example
Find patches related to bulletin
patch.bulletin: MS-17-NET-04
Use a text value ##### to find patches of certain category (Security Patches, Software Distribution, Security Tools, Non-security Patches, Custom Actions).
Example
Show patches of category Security Patches
patch.category: "Security Patches"
Use a text value ##### to find patches by certain CVE ID.
Example
Find patches for this CVE ID
patch.cveId: CVE-208-0760
patch.downloadMethodpatch.downloadMethod
Use a text value ##### to find patches by certain download method (Automatic, Unavailable, AcquireFromVendor).
- Automatic - Patch downloadable via the Cloud Agent (Qualys Patchable: Yes)
- AcquireFromVendor - Patch must be acquired from the vendor and installed manually (Qualys Patchable: No)
- Unavailable - Patch information is not available (Qualys Patchable: No)
Example
Find unavailable patches
patch.downloadMethod: unavailable
patch.isEnabledVendorAcquiredPatchespatch.isEnabledVendorAcquiredPatches
Use the values true | false to find vendor-acquired patches that are enabled
Example
Show vendor-acquired patches that are enabled
patch.isEnabledVendorAcquiredPatches: true
patch.isRollbackpatch.isRollback
Use the values true | false to find patches which are rolled back.
Example
Show rolled back patches
patch.isRollback: true
patch.isSecuritypatch.isSecurity
Use the values true | false to find patches of type Security.
Example
Show security patches
patch.isSuperseded: true
patch.isSupersededpatch.isSuperseded
Use the values true | false to find patches superseded by one or more replacement patches.
Example
Show superseded patches
patch.isSuperseded: true
patch.isEsuPatchpatch.isEsuPatch
Use the values true | false to find the Extended Security Update (ESU) patches.
Examples
Show a list of ESU patches.
patch.isEsuPatch: true
Show a list of non-ESU patches.
patch.isEsuPatch: false
Use a text value ##### to find patches with KB number issued by Microsoft for individual patch (Microsoft only).
Example
Find patches related to KB number
patch.kb: KB401572
patch.updatedDatepatch.updatedDate
Use a date range or specific date to find when patches were last modified.
Examples
Show patches modified within certain dates
patch.updatedDate: [2018-02-01 ... 2018-02-12]
Show patches modified starting 2018-02-01, ending 1 month ago
patch.updatedDate: [2018-02-01 ... now-1M]
Show patches modified starting 2 weeks ago, ending 1 second ago
patch.updatedDate: [now-2w ... now-1s]
Show patches modified on certain date
patch.updatedDate:'2018-02-22'
Use a text value ##### to find patches by patch ID.
Example
Find patches with this ID
patch.id: 8fc0797d-2c7b-3c08-8e7b-48c30585a702
Use values within quotes or backticks to find products affected by a patch.
Examples
Find products related to name
patch.product: Internet Explorer
Find products that contain parts of name
patch.product: "Update for Internet Explorer 11 for Windows 8.1;
Find products that match exact value
patch.product: `Update for Internet Explorer 11 for Windows 8.1 for x64-based systems (KB2901549)`
patch.publishedDatepatch.publishedDate
Use a date range or specific date to find when patches were last published.
Examples
Show patches published within certain dates
patch.publishedDate: [2018-02-01 ... 2018-02-12]
Show patches published starting 2018-02-01, ending 1 month ago
patch.publishedDate: [2018-02-01 ... now-1M]
Show patches published starting 2 weeks ago, ending 1 second ago
patch.publishedDate: [now-2w ... now-1s]
Show patches published on certain date
patch.publishedDate:'2018-02-22'
Use a text value ##### to find patches by certain QID.
Example
Find patches for this QID
patch.qid: 3015321
patch.isRebootRequiredpatch.isRebootRequired
Use the values true | false to find patches that require reboot.
Example
Show patches where reboot is required
patch.isRebootRequired: true
patch.supersededBypatch.supersededBy
Use a text value ##### to find patches that are superseded by other patch (patch ID).
Example
Find patches that are superseded by this patch
patch.supersededBy: 8fc0797d-2c7b-3c08-8e7b-48c30585a702
patch.supersedespatch.supersedes
Use a text value ##### to find patches that supersede other patch (patch ID).
Example
Find patches that supersede this patch
patch.supersedes: 8fc0797d-2c7b-3c08-8e7b-48c30585a702
Use values within quotes or backticks to find patches with certain title.
Examples
Find patches related to title
patch.title: Security
Find patches that contain parts of title
patch.title: "Security and Quality Rollup for the .Net Framework"
Find patches that match exact value
patch.title: `Security for the .Net Framework`
Use a text value ##### to find patches of certain type (OS, Application).
Example
Show patches of type Application
patch.type: "Application"
Use values within quotes or backticks to find patches from a certain vendor.
Examples
Find patches related to vendor name
patch.vendor: Microsoft
Find patches that contain parts of vendor name
patch.vendor: "Microsoft Corporation"
Find patches that match exact value
patch.vendorLink: `Microsoft`
patch.vendorLinkpatch.vendorLink
Use quotes or backticks within values to find URL of a certain vendor.
Examples
Find Vendor URL related to URL
patch.vendorLink: https://support.microsoft.com
Find Vendor URL that contain parts of vendor name
patch.vendorLink: "Microsoft"
Find Vendor URL that match exact value
patch.vendorLink: `https://support.microsoft.com/en-us/kb/3114739`
patch.vendorSeveritypatch.vendorSeverity
Use a text value ##### to find patches with certain vendor assigned severity level (Critical, Important, Moderate, Low, None).
Example
Find patches with this vendor assigned severity level
patch.vendorSeverity: Critical