vPatchApprovalPolicyStatus

The patch approval status of a patch by patch policy.

Column Name

Type

Purpose

UpdateClassificationCode

smallint(5), not null

Update classification:

100 -> Security Update – Critical

101 -> Security Update – Important

102 -> Security Update – Moderate

103 -> Security Update – Low

104 -> Security Update – Unrated

110 -> Critical Update

120 -> Update Rollup

200 -> Service Pack

210 -> Update

220 -> Feature Pack

230 -> Tool

900 -> Unclassified

999 -> Kaseya Patch Test

UpdateClassification

varchar(43), not null

Same as UpdateClassification in string format.

Approved

int(10), null

Number of patch policies in which this patch is approved

Denied

int(10), null

Number of patch policies in which this patch is denied

Pending

int(10), null

Number of patch policies in which this patch is pending

Totals

int(10), null

Total number of patch policies in which this patch is approved, denied or pending

Product

varchar(300), null

Product to which patch is associated

Policy

varchar(100), null

Patch Policy Name

UpdateClassificationDefaultApprovalCode

smallint(5), not null

0 – Approved

1 - Denied

2 - Pending

UpdateClassificationDefaultApproval

varchar(8), not null

Approved, Pending, Denied

ProductDefaultApprovalCode

smallint(5), not null

0 – Approved

1 - Denied

2 - Pending

ProductDefaultApproval

varchar(8), not null

Approved, Pending, Denied

partitionId

numeric(26,0), not null

Tenant identifier (see partnerPartition table)