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

SecurityBulletin

varchar

bulletin ID string reported from the patch scanner

Title

varchar

UpdateClassification

smallint

InstallSeparate

tinyint

IsSuperseded

tinyint

PatchAppliedFlag

int

0 -> patch has not been applied

1 -> patch has been applied

PatchStatus

int

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)