vPatchApprovalStatus

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

Column Name

Type

Purpose

patchDataId

int(10), not null

Unique identifier for this patch within the database

KBArticle

varchar(12), not null

Microsoft knowledge base article number

SecurityBulletin

varchar(40), not null

Microsoft security bulleting number

Title

varchar(250), not null

Patch title

UpdateClassificationId

smallint(5), not null

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(43), not null

Textual representation of the patch update classification

Product

varchar(300), null

Product this to which this patch is associated

PublishedDate

datetime(3), null

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

Language

varchar(30), not null

Language support for the patch

numApproved

int(10), null

Number of patch policies in which this patch is approved

numDenied

int(10), null

Number of patch policies in which this patch is denied

numPending

int(10), null

Number of patch policies in which this patch is pending approval

InstallationWarning

varchar(20), not null

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