vPatchConfiguration

Provides the various patch-related configurations. There is one row per 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.

MachineName

varchar(100), null

Machine Name used for each agent

GroupName

varchar(100), null

Group Name used for each agent

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(166), 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

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