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

A concatenated representation of the machine id and the group id it is associated with.

agentGuid

numeric

A globally unique identifier for a machine ID.group ID account and its corresponding agent.

MachineName

varchar

Machine Name used for each agent

GroupName

varchar

Group Name used for each agent

KBArticle

varchar

Microsoft KB article number reported from the patch scanner.

SecurityBulletin

varchar

bulletin ID string reported from the patch scanner

Title

varchar

Update title.

Product

varchar

Product to which patch is associated

UpdateClassification

smallint

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

ReleaseDate

datetime

Patch release date

InstallSeparate

tinyint

0 -> this can be installed together with other patches

1 -> this must be installed separately (its own reboot) from other patches

IsSuperseded

tinyint

0 -> update is not superseded

1 -> update is superseded by a subsequent update

PatchAppliedFlag

int

0 -> patch has not been applied

1 -> patch has been applied

PatchStatus

int

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

PatchIgnoreFlag

int

0 -> process this patch

1 -> ignore this patch

InstallDate

dateTime

timestamp when this patch was applied by the VSA

InstalledBy

varchar

Name of admin (if we installed the patch) or value from registry (if scanner retuned the value)

InstallationWarning

varchar

Returns 'Manual Install Only', 'Windows Update Only', 'Product Upgrade Only', or an empty string.

Description

varchar

Patch description

UninstallNotes

varchar

Uninstall notes for the patch