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