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 |