vPatchStatus
|
vPatchStatus |
Shows the state of all patches on a per machine basis. There is one row per patch for each machine. |
|
|
Column Name |
Type |
Purpose |
|
Machine_GroupID |
varchar(201), null |
A concatenated representation of the machine id and the group id it is associated with. |
|
agentGuid |
numeric(26,0), not null |
A globally unique identifier for a machine ID.group ID account and its corresponding agent. |
|
MachineId |
varchar(201), null |
Machine name used for each agent. |
|
ComputerName |
varchar(80), null |
holds the computer name found in the OS |
|
ReverseGroupName |
varchar(100), null |
Machine group, then organization the machine is assigned to. |
|
GroupName |
varchar(100), not null |
Organization, then machine group the machine is assigned to. |
|
OperatingSystem |
varchar(16), null |
Operating system of the computer. |
|
OSInformation |
varchar(150), null |
Operating system information. |
|
CurrentUser |
varchar(100), null |
Currently logged on user. |
|
LastLoggedOnUser |
varchar(100), null |
Previously logged on user. |
|
KBArticle |
varchar(10), not null |
Microsoft KB article number reported from the patch scanner. |
|
SecurityBulletin |
varchar(40), not null |
Bulletin ID string reported from the patch scanner. |
|
Title |
varchar(250), not null |
Update title. |
|
Product |
varchar(300), not null |
Product to which patch is associated |
|
Language |
varchar(30), null |
Language of the product. |
|
UpdateClassification |
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 |
|
UpdateClassificationDescription |
varchar(43), not null |
Same as UpdateClassification in string format. |
|
ReleaseDate |
datetime(3), null |
Patch release date |
|
ApprovalStatus |
smallint(5), not null |
0 -> approved 1 -> disapproved 2 -> pending approval |
|
ApprovalStatusDescription |
varchar(16), not null |
Same as ApprovalStatus in string format. |
|
InstallSeparate |
tinyint(3), not null |
0 -> this can be installed together with other patches 1 -> this must be installed separately (its own reboot) from other patches |
|
IsSuperseded |
tinyint(3), not null |
0 -> update is not superseded 1 -> update is superseded by a subsequent update |
|
PatchAppliedFlag |
int(10), not null |
0 -> patch has not been applied 1 -> patch has been applied |
|
PatchStatus |
int(10), not null |
0 -> this patch not scheduled to be installed 1 -> schedule this patch for install. Flags used to bundle all patches into a single script. Set when installation scripts are generated. 2 -> patch install failed, no alert sent 3 -> patch install failed and alert has been sent 4 -> patch installed and awaiting a reboot to reconfirm 5 -> schedule rollback for this patch 6 -> “/install-as-user” patch not installed; User not logged in 7 -> Office patch not installed; User request to install declined or timed out 8 -> patch get/install failed, client login credential is invalid |
|
PatchStatusDescription |
varchar(42), not null |
Same as PatchStatus is string format. |
|
PendingManualInstall |
int(10), not null |
Patch selected by manual update (Machine Update or Patch Update): 0 -> not selected for installation 1 -> selected for installation |
|
PatchIgnoreFlag |
int(10), not null |
0 -> process this patch 1 -> ignore this patch |
|
InstallationWarning |
varchar(22), not null |
Returns 'Manual Install Only', 'Windows Update Only', 'Product Upgrade Only', “Internet-based Install”, or an empty string. |
|
InstallDate |
datetime(3), null |
timestamp when this patch was applied by the VSA |
|
InstalledBy |
varchar(100), null |
Name of admin (if we installed the patch) or value from registry (if scanner retuned the value) |
|
Description |
varchar(1500), null |
Patch description |
|
UninstallNotes |
varchar(1500), null |
Uninstall notes for the patch |
|
patchDataId |
int, not null |
Key to the patchData table. |
