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 |
|
|