vPatchPolicyMember
|
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 |