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 |