vBaseDriveManufacturer

vCurrDriveManufacturer

Hardware audit results for the IDE & SCSI drives manufacturer and product info found in a client desktop machine.  One entry per drive from an audit of a client desktop.

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), null

A globally unique identifier for a machine ID.group ID account and its corresponding agent.

DriveManufacturer

varchar(100), null

Manufacturer name (data currently has 8 characters max)

DriveProductName

varchar(100), null

Product identification (data currently has 16 characters max)

DriveProductRevision

varchar(40), null

Product revision (data currently has 4 characters max)

DriveType

varchar(9), not null

Type of disk drive found