Next Topic

Previous Topic

Book Contents

vPatchPieChartCountsNoPolicy

vPatchPieChartCountsNoPolicy

Provides patch counts for machines without an assign policy.

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

Unique 26 digit random number identifying this agent. Master record stored in machNameTab.

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.

Category

varchar(26), not null

  • Not Scanned
  • Missing Patches: 0
  • Missing Patches: 1-2
  • Missing Patches: 3-5
  • Missing Patches: 6 or more
  • OS Not Supported