Stores detected patches in a scan result, indicating whether they are installed or not
Data model
Fields
| Field | Type | Description |
|---|---|---|
| created_date* | DATETIME | Date you registered? The result of the patch on the scan |
| is_installed* | BIT | Indicates if the patch is ? installed or pending installation on the scanned device |
| patch_id* | INT | Identifier of the patch detected in the scan |
| scan_result_id* | INT | Scan result identifier |
Primary Key
| PK_APM_SCAN_PATCH |
|---|
| scan_result_id, patch_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| patch_id* | dbo.APM_PATCH | id | FK02_APM_SCAN_PATCH |
| scan_result_id* | dbo.APM_SCAN_RESULT | id | FK01_APM_SCAN_PATCH |