Device policy fields:
MI_DEVICE_POLICY table
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 |