vPatchApprovalStatus

Show the approval status of a patch. There is one row for each active patch.

Column Name

Type

Purpose

patchDataId

int

Unique identifier for this patch within the database

KBArticle

varchar

Microsoft knowledge base article number

SecurityBulletin

varchar

Microsoft security bulleting number

Title

varchar

Patch title

UpdateClassificationId

smallint

Numeric representation of the patch update classification; included to make filtering easier; Values are:

100 = Critical Security Update (High Priority)

101 = Important Security Update (High Priority)

102 = Moderate Security Update (High Priority)

103 = Low Security Update (High Priority)

104 = Non-rated Security Update (High Priority)

110 = Critical Update (High Priority)

120 = Update Rollup (High Priority)

200 = Service Pack (Optional)

210 = Update (Optional)

220 = Feature Pack (Optional)

230 = Tool (Optional)

UpdateClassification

varchar

Textual representation of the patch update classification

Product

varchar

Product this to which this patch is associated

PublishedDate

datetime

Date that this patch was last update by Microsoft, if available

Language

varchar

Language support for the patch

numApproved

int

Number of patch policies in which this patch is approved

numDenied

int

Number of patch policies in which this patch is denied

numPending

int

Number of patch policies in which this patch is pending approval

InstallationWarning

varchar

Returns 'Manual Install Only', 'Windows Update Only', 'Product Upgrade Only', or an empty string.