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.

machName

varchar

Machine Name used for each agent

groupName

varchar

Group Name used for each agent

BulletinID

varchar

bulletin ID string reported from the patch scanner

QNumber

int

Q Number for this patch. Refers to the Knowledge Base article on Microsofts site

FixedInServPackFlag

int

0 -> not part of a service pacelse the service pac ID that this patch has been incorporated into.

PatchAppliedFlag

int

0 -> patch has not been applied

1 -> patch has been applied

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)