2.23 NC_LogicalDrive Table

The NC_LogicalDrive table contains inventory data about logical drives.

Column

Key

Type

Null

Description

ComponentOID

PK, FK

binary(16)

No

An internal ID number used as a primary key.

DriveNumber

smallint

The number of the drive.

DriveLetter

nvarchar(64)

The drive letter (without a colon).

AvailableSpace

Float

The free space on this drive.

TotalSpace

Float

The total space on this drive.

LogicalNumber

smallint

The sequential number of this drive on the disk.

IsRemote

smallint

No

True(1) indicates if the drive is networked; else 0.

FileSystem

smallint

The file system: 0=Unknown, 1=FAT, 2=FAT 32, 3=NTFS, 4=HPFS, 5=NetWare, 6=Xenix, 7=Linux, 8=UNIX, 9=AIX, 10=Mac, 11=Hidden.

VolumeLabel

nvarchar(64)

The volume name of the drive.

VolumeSerialNumber

nvarchar(32)

The serial number of the drive.

UNCPath

nvarchar(100)

The UNC path of the drive.

NOTE:The ComponentOID foreign key references the ComponentOID primary key column of the NC_LogicalDriveComp table.