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

Unique identifier for this patch within the database

Policy

varchar(100), null

Name of patch policy

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

ApprovalStatusId

smallint(5), not null

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

0 = Approved

1 = Denied

2 = Pending Approval

ApprovalStatus

varchar(16), not null

Textual representation of the patch approval status

Admin

varchar(100), not null

Name of user 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(3), not null

Timestamp of most recent approval status change

InstallationWarning

varchar(20), not null

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

StatusNotes

varchar(500), not null

Notes added by Admin concerning the patch approval status