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
The total space on this drive.
LogicalNumber
The sequential number of this drive on the disk.
IsRemote
1 (TRUE) if the drive is networked; else 0.
FileSystem
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
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_Component table.