Detail of the execution of a remediation action on a device
Data model
Fields
| Field | Type | Description |
|---|---|---|
| action_id* | INT | Action ID |
| device_id* | UNIQUEIDENTIFIER | Device Identifier |
| error_message | VARCHAR (4000) | Error message when executing the action |
| last_updated* | DATETIME2 | Status Update Date |
| state* | INT | Execution status on the device |
Primary Key
| PK_AES_DEVICE_REMEDIATION |
|---|
| device_id, action_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| action_id* | dbo.AES_REMEDIATION_ACTION | id | FK02_AES_DEVICE_REMEDIATION |
| device_id* | dbo.AES_DEVICE | id | FK01_AES_DEVICE_REMEDIATION |