Device configurations:
MI_DEVICE_CONFIG table

The MI_DEVICE_CONFIG table contains a record for each device/configuration association.

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, maps to config_id in mi_config table

device_uuid

varchar(64)

No

No

UUID of the device, maps to device_uuid in mi_device table

status

varchar(1)

No

No

Status of the policy:

'P' - Pending

'S' - Sent

'A' - Applied

'F' - Failed

'R' - Revoked

'Q' - Quarantine Revoked

'U' - Update Pending

'V' - Update Failed

'X' - Unknown

last_updated_at

timestamp

No

No

Last change in status or created timestamp