Consolidates patch information, download status, associated categories, and installation status on active devices
Fields
| Field | Type | Description |
|---|---|---|
| category_id | INT | Identifier of the category associated with the patch |
| description | VARCHAR (MAX) | Patch Description |
| download_date | DATETIME | Date the patch was downloaded (if applicable) |
| download_id | INT | Patch download log ID |
| download_status_id | INT | Current status of the patch download |
| external_patch_id* | UNIQUEIDENTIFIER | Vendor-provided patch external identifier |
| installed_count | INT | Number of active devices where the patch is installed |
| is_installed* | INT | Indicates whether the patch is installed on all active devices |
| kb_id | VARCHAR (32) | Patch KB ID (if applicable) |
| not_installed_count | INT | Number of active devices where the patch is not installed |
| patch_id* | INT | Patch ID |
| publish_date | DATETIME | Official Patch Release Date |
| schedule_date | DATETIME | Scheduled Patch Download Date |
| severity* | SMALLINT | Patch severity level (e.g., critical, low) |
| size | BIGINT | Patch file size in bytes |
| title* | VARCHAR (1024) | Descriptive Patch Title |
| url_release_note | VARCHAR (1024) | URL to the patch release notes |
| version | VARCHAR (20) | Patch version |