vPatchPolicy

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

Column Name

Type

Purpose

patchDataId

int

Unique identifier for this patch within the database

Policy

varchar

Name of patch policy

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

ApprovalStatusId

smallint

Numeric representation of the patch approval status; included to make filtering easier; Values are:

0 = Approved

1 = Denied

2 = Pending Approval

ApprovalStatus

varchar

Textual representation of the patch approval status

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

Admin

varchar

Name of administrator that made the most recent status change ("*System*" indicates that the approval status was set by the system based upon patch policy default approval status or by KB Override)

Changed

datetime

Timestamp of most recent approval status change

StatusNotes

varchar

Notes added by Admin concerning the patch approval status

InstallationWarning

varchar

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