PatchMetadata

PatchMetadata

Column Name

Type

Nullable

Description

Column Name

Type

Nullable

Description

PatchGUID

unique-identifier

No

Uniquely identifies the patch

PatchClassification

string

No

The classification of the patch

PatchProducts

text

No

Identifies the applications the patch is applied to

PublicationState

string

No

The publication state of the patch

MSRCSeverity

string

No

The severity of the patch according to the Microsoft Security Response Center

KBArticleNumber

string

Yes

The Knowledge Base article the patch relates to

PatchReleaseDate

datetime

Yes

The date and time the patch was released

PatchClassificationDate

datetime

Yes

The date and time the patch was classified

iscurrent

character

Yes

Not used