Policy-related fields:
MI_POLICY table

The MI_POLICY table contains the exported details for all Ivanti EPMM policies, regardless of whether they are currently applied to devices.

Name Data type Not Null? Primary key? Description

etl_run_ts

timestamp

Yes

No

Timestamp at which the ETL process has run

vsp_id

integer

No

No

The identifier of VSP from which this policy got exported

policy_id

integer

No

No

Identifier of the policy

policy_uuid

varchar(64)

No

No

UUID of the policy

policy_name

varchar(64)

No

No

Name of the policy

priority

integer

No

No

Priority of the policy over other similar type of policies applied to the device

active

varchar(1)

No

No

Whether the policy is active

user_override

varchar(1)

No

No

Always 'f', not used

policy_type

varchar(64)

No

No

Whether it is a DEFAULT policy or ENTERPRISE(Admin created) policy or DEVICE policy

profile_type

varchar(64)

No

No

Type of policy profile, LOCKDOWN, PRIVACY, SECURITY, SYNC, ACTIVESYNC, USER, DOCS, GLOBALHTTPPROXY, SINGLEAPPMODE, KIOSK, APPCONNECT, SAMSUNG_GENERAL, ANDROIDQUICKSETUP

description

varchar(255)

No

No

Policy description that admin configured

hash

varchar(64)

No

No

Fingerprint of all the associated rules of this policy

created_at

timestamp

No

No

Date and time at which this policy is created

version

integer

No

No

Version policy, number of times the policy got modified

last_modified_at

timestamp

No

No

Last modified date and time

created_by

integer

No

No

The id of the user who created this policy, maps to user_id in mi_user table, if a device is registered to this user. 9000 is the default id for the system created default policies

last_modified_by

integer

No

No

Id of the user who modified the policy