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 |
