vPatchApprovalPolicyStatus
|
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) |
