vPatchPolicy
|
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 |
|
partitionId |
numeric(26,0),not null |
The unique tenant partition identifier for a shared Kaseya Server and database. |
