Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
ComputerID | INT | 10 | null |
|
|
|||||
HotfixID | VARCHAR | 40 | null |
|
|
|||||
PatchManufacturer | VARCHAR | 255 | Microsoft |
|
|
|||||
PatchProduct | VARCHAR | 255 | null |
|
|
|||||
PatchOS | VARCHAR | 100 | null |
|
|
|||||
PatchIsInstalled | INT | 10 | null |
|
|
|||||
PatchIsCWAInstalled | INT | 10 | null |
|
|
|||||
PatchInstalledDate | DATETIME | 19 | √ | null |
|
|
||||
PatchApproveAction | VARCHAR | 12 |
|
|
||||||
PatchUpdateAction | VARCHAR | 14 |
|
|
||||||
PatchVersionInstalled | VARCHAR | 100 |
|
|
||||||
PatchVersionApproved | VARCHAR | 255 | √ | null |
|
|
||||
PatchVersionLatest | VARCHAR | 255 | √ | null |
|
|
||||
PatchVersionCompliant | INT | 10 | √ | null |
|
|