vPatchConfiguration

Provides the various patch-related configurations. There is one row per machine.

Column Name

Type

Purpose

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

The machine name, machine group and organization assigned to a machine.

Machine_GroupID

varchar(201), null

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

MachineName

varchar(80), 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.

PatchScanTypeSetting

int(10), not null

Type of patch scan:

-1 = OS not supported for patch scans

0 = Legacy Patch Scan

1 = WUA Patch Scan (32-bit)

2 = WUA Patch Scan (64-bit)

PatchScanType

varchar(300), null

Type of patch scan description

RebootSetting

int(10), not null

Post patch installation reboot action:

0 = Reboot immediately

1 = Ask - Do nothing if user does not respond in <RebootWarnMinutes> minutes

2 = Do not reboot after update; If exists, send email to <RebootWarningEmailAddress>

3 = Ask - Reboot if user does not respond in <RebootWarnMinutes> minutes

4 = Warn user that machine will reboot in <RebootWarnMinutes> minutes

5 = Skip reboot if user logged in

6 = Reboot on <RebootDay> at <RebootTime> after install

7 = Ask to reboot every <RebootWarnMinutes> minutes

RebootAction

varchar(143), null

Post patch installation reboot action description

PreRebootScript

varchar(260), not null

scriptId of script to execute immediately before the reboot step in the Patch Reboot script

PostRebootScript

varchar(260), not null

scriptId of script to execute immediately after the patch reboot (from scriptAssignmentReboot)

RebootWarnMinutes

int(10), null

Warning wait period in minutes for RebootSetting 1,3,4,7

RebootDay

int(10), null

Day to force patch reboot for RebootSetting 6:

0 = Everyday

1 = Sunday

2 = Monday

3 = Tuesday

4 = Wednesday

5 = Thursday

6 = Friday

7 = Saturday

RebootTime

varchar(10), null

Time to force patch reboot for RebootSetting 6

RebootWarningEmailAddress

varchar(100), null

Email address to send email for post patch installation reboot for RebootSetting 2

FileSourceSetting

int(10), not null

Patch installation file source:

0 = From Internet

1 = From system server

2 = From file server

FileSourceConfig

varchar(169), not null

Patch installation file source description

UseAgentTempDirOnDriveMostFreeSpace

int(10), not null

Destination for downloaded patch file:

0 = Use configured Agent working drive/directory

1 = Use configured Agent working directory on local disk drive having most free space

DeleteAfterInstall

int(10), not null

Delete downloaded patch file after installation:

0 = Do not delete

1 = Delete

FileSourceMachineId

varchar(201), null

MachineGroup_ID for the file server for FileSourceSetting 2

FileSourceUNCPath

varchar(300), null

UNC path for the file server for FileSourceSetting 2

FileSourceLocalPath

varchar(300), null

Local machine path for the file server for FileSourceSetting 2

LanCacheName

varchar(200), null

The name of the LAN Cache.

LanCacheMachineId

varchar(201), null

The machine id of the machine hosting the LAN Cache.

LanCacheUNCPath

varchar(260), null

The UNC path to the LAN Cache.

LanCacheLocalPath

varchar(260),null

The local directory path to the LAN Cache.

UseInternetSourceAsFallback

int(10), null

If file server not accessible, fall back to use the Internet for FileSourceSetting 2

WinAutoUpdateSetting

int(10), not null

Windows Automatic Update setting

0 = Windows automatic Updates configuration set; Cannot be changed by user on the machine

1 = Windows automatic Updates disabled; Cannot be changed by user on the machine

2 = User control

WinAutoUpdateConfig

varchar(93), null

Windows Automatic Update description