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.