vBaseDiskInfo

vCurrDiskInfo

audit results for the logical disks found in a client desktop machine.  One entry per logical disk 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.

machName

varchar(100), null

Machine Name used for each agent

groupName

varchar(100), null

Organization, then machine group the machine is assigned to.

DriveLetter

varchar(100), null

Logical disk drive letter (e.g. C)

TotalSpace

int(10), null

Total MBytes on the disk (e.g. 28609 for 28.609 GB) May be null if unavailable.

UsedSpace

int(10), null

Number of MBytes used (e.g. 21406 for 21.406 GB). May be null if unavailable.

FreeSpace

int(10), null

Number of MBytes free (e.g. 21406 for 21.406 GB). May be null if unavailable.

DriveType

varchar(40), null

Fixed = hard diskRemovable = floppy or other removable mediaCDROMNetwork = mapped network drive

VolumeName

varchar(100), null

Name assigned to the volume

FormatType

varchar(16), null

NTFS, FAT32, CDFS, etc.