Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
DriveID | INT | 10 | 0 |
|
|
|||
ClientID | INT | 10 | 0 |
|
|
|||
LocationID | INT | 10 | 0 |
|
|
|||
LocationName | VARCHAR | 50 | null |
|
|
|||
ComputerID | INT | 10 | 0 |
|
|
|||
ComputerName | VARCHAR | 50 | null |
|
|
|||
ComputerIsServer | TINYINT | 3 | null |
|
|
|||
DriveLetter | VARCHAR | 30 | null |
|
|
|||
DriveSize | INT | 10 | 0 |
|
|
|||
DriveFree | INT | 10 | 0 |
|
|
|||
DriveUsed | BIGINT | 19 | 0 |
|
|
|||
DriveFileSystem | VARCHAR | 20 | null |
|
|
|||
DriveModel | VARCHAR | 35 | null |
|
|
|||
DriveSmartData | VARCHAR | 500 | 0 |
|
|
|||
DriveLastCheckin | TIMESTAMP | 19 | 0000-00-00 00:00:00 |
|
|
|||
DriveVolumeName | VARCHAR | 200 |
|
|
||||
DriveIsSSD | BIT | 1 | null |
|
|
|||
DriveIsAvailable | INT | 10 | 0 |
|
|
|||
DriveIsInternal | BIT | 1 | null |
|
|
|||
DriveIsVirtual | INT | 10 | 0 |
|
|
|||
SmartAttributeTotal | BIGINT | 19 | 0 |
|
|
|||
SmartAttributeFailed | DECIMAL | 23 | √ | null |
|
|