Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ClientID | INT | 10 | 0 |
|
|
|||||
| LocationID | INT | 10 | 0 |
|
|
|||||
| LocationName | VARCHAR | 50 | null |
|
|
|||||
| ComputerID | INT | 10 | 0 |
|
|
|||||
| ComputerName | VARCHAR | 50 | null |
|
|
|||||
| ComputerIsServer | TINYINT | 3 | null |
|
|
|||||
| ComputerLocalIP | VARCHAR | 30 | null |
|
|
|||||
| ComputerOSType | VARCHAR | 7 |
|
|
||||||
| ComputerOS | VARCHAR | 255 | √ | null |
|
|
||||
| DefScheduleID | INT | 10 | √ | 0 |
|
|
||||
| ComputerDateAgentAdded | DATETIME | 19 | null |
|
|
|||||
| ComputerDateAddedLT | DATETIME | 19 | null |
|
|
|||||
| BackupSchedulePattern | VARCHAR | 1024 | √ | null |
|
|
||||
| BackupRisk | VARCHAR | 20 |
|
|
||||||
| JobsFailedTotal | DECIMAL | 23 | √ | null |
|
|
||||
| JobsFailed1d | DECIMAL | 23 | √ | null |
|
|
||||
| JobsFailed7d | DECIMAL | 23 | √ | null |
|
|
||||
| JobsFailed15d | DECIMAL | 23 | √ | null |
|
|
||||
| JobsFailed30d | DECIMAL | 23 | √ | null |
|
|
||||
| JobsSucceededTotal | DECIMAL | 23 | √ | null |
|
|
||||
| JobsSucceeded1d | DECIMAL | 23 | √ | null |
|
|
||||
| JobsSucceeded7d | DECIMAL | 23 | √ | null |
|
|
||||
| JobsSucceeded15d | DECIMAL | 23 | √ | null |
|
|
||||
| JobsSucceeded30d | DECIMAL | 23 | √ | null |
|
|
||||
| JobIsLastSucceeded | INT | 10 | 0 |
|
|
Relationships
Close relationships within degrees of separation
