Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| HotFixID | VARCHAR | 40 | null |
|
|
|||
| kbID | VARCHAR | 30 | null |
|
|
|||
| Title | VARCHAR | 255 | null |
|
|
|||
| Category | INT | 10 | null |
|
|
|||
| DownloadURL | VARCHAR | 1000 | null |
|
|
|||
| FileName | VARCHAR | 255 | null |
|
|
|||
| Switches | VARCHAR | 255 | null |
|
|
|||
| Restart | INT | 10 | null |
|
|
|||
| OS | VARCHAR | 100 | null |
|
|
|||
| Date_Added | DATETIME | 19 | null |
|
|
|||
| Description | VARCHAR | 1024 | null |
|
|
|||
| SupportURL | VARCHAR | 255 | null |
|
|
|||
| Severity | VARCHAR | 50 | null |
|
|
|||
| CategoryName | VARCHAR | 255 | null |
|
|
|||
| PatchType | VARCHAR | 25 | null |
|
|
|||
| Uninstall | INT | 10 | 0 |
|
|
|||
| Ignore | INT | 10 | null |
|
|
|||
| Discovered | INT | 10 | null |
|
|
|||
| Missing | INT | 10 | null |
|
|
|||
| LabTechApproved | INT | 10 | null |
|
|
|||
| CommunityApproved | INT | 10 | null |
|
|
|||
| UserApproved | INT | 10 | null |
|
|
|||
| CVSS | DOUBLE | 22 | null |
|
|
|||
| IsThirdParty | INT | 10 | null |
|
|
|||
| Bulletin | VARCHAR | 255 | null |
|
|
|||
| SoftwareDefinition | TEXT | 65535 | null |
|
|
|||
| Manufacturer | VARCHAR | 255 | Microsoft |
|
|
|||
| Version | VARCHAR | 100 | null |
|
|
|||
| ApprovalPolicyCount | INT | 10 | null |
|
|
|||
| Availability | INT | 10 | null |
|
|
|||
| LTProductKey | VARCHAR | 36 | null |
|
|
|||
| IsOperatingSystemPatch | INT | 10 | null |
|
|
|||
| OS_Build | VARCHAR | 100 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | HotFixID + OS |
| CategoryName | Performance | Asc | CategoryName |
| Discovered | Performance | Asc | Discovered |
| HotFixDataIsThirdParty | Performance | Asc | IsThirdParty |
| HotFixDataLTProductKey | Performance | Asc | LTProductKey |
| Missing | Performance | Asc | Missing |
| OS | Performance | Asc | OS |
| Severity | Performance | Asc | Severity |
| Title | Performance | Asc | Title |
Diagram producer might be missing
No diagrams were produced please see application output for any errors