Configurations: MI_CONFIG table
The MI_CONFIG table contains a record for each configuration defined in Ivanti EPMM, regardless of whether it has been applied to a device.
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 |
config_id | integer | No | No | Identifier of the configuration |
config_uuid | varchar(64) | No | No | UUID of the configuration |
config_name | varchar(64) | No | No | Name of the configuration |
config_type | varchar(64) | No | No | Type of the configuration, SCEP, EXCHANGE, WIFI, CERTIFICATE, VPN, RESTRICTION, WEBCLIP etc. |
config_source | varchar(64) | No | No | Source of the configuration, SYSTEM - System created, ADMIN - Admin created |
description | varchar(255) | No | No | Configuration description that admin configured |
hash | varchar(64) | No | No | Fingerprint of all the associated entries of this configuration |
created_at | timestamp | No | No | Date and time at which this configuration is created |
version | integer | No | No | Version policy, number of times the configuration 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 |
