vSystemInfo

Data collected by the System Info function.

Column Name

Type

Purpose

Machine_GroupID

varchar(201), null

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

machName

varchar(100), null

Machine Name used for each agent

groupName

varchar(100), null

Organization, then machine group the machine is assigned to.

Manufacturer

varchar(100), null

System manufacturer string

Product Name

varchar(100), null

Name or model number of the machine supplied by the manufacturer

System Version

varchar(100), null

Machine version string

System Serial Number

varchar(100), null

Machine serial number string entered by the manufacturer

Chassis Serial Number

varchar(100), null

Serial number string supplied by the manufacturer

Chassis Asset Tag

varchar(100), null

Asset tag string supplied by the manufacturer

External Bus Speed

varchar(100), null

Motherboard bus speed

Max Memory Size

varchar(100), null

Max memory this system may be configured with

Max Memory Slots

varchar(100), null

Max number of memory slots this system has

Chassis Manufacturer

varchar(100), null

Name of manufacturer of the chassis

Chassis Type

varchar(100), null

system chassis type

Chassis Version

varchar(100), null

version string of the chassis

Motherboard Manufacturer

varchar(100), null

Name of motherboard manufacturer

Motherboard Product

varchar(100), null

Motherboard model name

Motherboard Version

varchar(100), null

Motherboard version number

Motherboard Serial Num

varchar(100), null

Motherboard serial number

Processor Family

varchar(100), null

processor family name

Processor Manufacturer

varchar(100), null

processor manufacturer name

Processor Version

varchar(100), null

processor version string

CPU Max Speed

varchar(100), null

max speed of this processor

CPU Current Speed

varchar(100), null

configured speed of this processor