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_Component table.