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