Device policy fields: MI_DEVICE_POLICY table
1 min
The MI_DEVICE_POLICY table contains a record for each device or policy association in Ivanti EPMM.
Name | Data type | Not Null? | Primary key? | Description |
|---|---|---|---|---|
device_uuid | varchar(64) | No | No | UUID of the device, maps to device_uuid in mi_device table |
etl_run_ts | timestamp | Yes | No | Timestamp at which the ETL process has run |
last_updated_at | timestamp | No | No | Last change in status or created timestamp |
policy_id | integer | No | No | Identifier of the policy, maps to policy_id in mi_policy table |
status | varchar(1) | No | No | Status of the policy: 'P' - Pending 'S' - Sent 'A' - Applied 'F' - Failed 'R' - Revoked 'Q' - Quarantine Revoked 'U' - Update Pending 'V' - Update Failed 'X' - Unknown |
vsp_id | integer | No | No | The identifier of VSP from which this policy got exported |
