vPatchPolicyMember

Lists all patch policies to which each machine ID is a member, if any.

Column Name

Type

Purpose

Machine_GroupID

varchar(201), null

A concatenated representation of the machine id and the group id to which it is associated

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

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.

PolicyName

varchar(100), not null

Patch Policy Name