---
title: Common device fields: MI_DEVICE table
slug: rdb/essentials-guide/common-device-fields-midevice-table
createdAt: 2026-11-05T09:24:41.781Z
---

The set of common device fields in the MI\_DEVICE table comprises data from various tables in the VSP database. The MI\_DEVICE table is the main/master table that stores all devices.

| Name                                        | Data type                   | Not Null? | Primary key? | Description                                                                                                                                                                                                                                                                                  |
| ------------------------------------------- | --------------------------- | --------- | ------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| etl\_run\_ts                                | timestamp without time zone | Yes       | No           | The time the snapshot is taken on VSP.                                                                                                                                                                                                                                                       |
| vsp\_id                                     | integer                     | No        | No           |                                                                                                                                                                                                                                                                                              |
| device\_id                                  | bigint                      | No        | No           | VSP device\_id. The combination of etl\_run\_ts + vsp\_id + device\_id makes the primary key for this table.                                                                                                                                                                                 |
| device\_uuid                                | character varying(64)       | No        | No           |                                                                                                                                                                                                                                                                                              |
| battery\_level                              | bigint                      | No        | No           | Indicates the device’s battery level.                                                                                                                                                                                                                                                        |
| blocked                                     | boolean                     | No        | No           | Indicates whether the device is blocked.                                                                                                                                                                                                                                                     |
| blocked\_reasons                            | character varying(256)      | No        | No           | Describes why the device is blocked. See the **MI\_DEVICE** fields:<br />- blocked\_reasons<br />- noncompliance\_reasons<br />- quarantined\_reasons<br />See [Array Value Enumerations](https://docs.ivanti.com/rdb/essentials-guide/array-value-enumerations) for more information.       |
| cellular\_technology                        | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| client\_build\_date                         | timestamp without time zone | No        | No           |                                                                                                                                                                                                                                                                                              |
| client\_id                                  | bigint                      | No        | No           |                                                                                                                                                                                                                                                                                              |
| client\_name                                | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| client\_version                             | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| comment                                     | character varying(256)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| compliant                                   | boolean                     | No        | No           |                                                                                                                                                                                                                                                                                              |
| current\_country\_code                      | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| current\_country\_name                      | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| current\_operator\_name                     | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| current\_phone\_number                      | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| device\_encrypted                           | boolean                     | No        | No           | Device is encrypted                                                                                                                                                                                                                                                                          |
| display\_size                               | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| eas\_last\_sync\_time                       | timestamp without time zone | No        | No           |                                                                                                                                                                                                                                                                                              |
| geographic\_coordinates                     | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| geographic\_coordinates\_capture\_time      | timestamp without time zone | No        | No           |                                                                                                                                                                                                                                                                                              |
| home\_country\_code                         | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| home\_country\_name                         | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| home\_operator\_name                        | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| home\_phone\_number                         | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| imei                                        | character varying(255)      | No        | No           | The device’s International Mobile Station Equipment Identity.                                                                                                                                                                                                                                |
| imsi                                        | character varying(255)      | No        | No           | The device’s International mobile Subscriber Identity.                                                                                                                                                                                                                                       |
| lang\_country\_id                           | bigint                      | No        | No           |                                                                                                                                                                                                                                                                                              |
| language                                    | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| language\_id                                | bigint                      | No        | No           |                                                                                                                                                                                                                                                                                              |
| last\_connected\_at                         | timestamp without time zone | No        | No           |                                                                                                                                                                                                                                                                                              |
| locale                                      | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| manufacturer                                | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| mdm\_managed                                | boolean                     | No        | No           |                                                                                                                                                                                                                                                                                              |
| memory\_capacity                            | bigint                      | No        | No           |                                                                                                                                                                                                                                                                                              |
| memory\_free                                | bigint                      | No        | No           |                                                                                                                                                                                                                                                                                              |
| model                                       | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| modified\_at                                | timestamp                   | No        | No           | When device details were modified.                                                                                                                                                                                                                                                           |
| noncompliance\_reasons                      | character varying(256)      | No        | No           | Describes why the device is non-compliant. See the **MI\_DEVICE** fields:<br />- blocked\_reasons<br />- noncompliance\_reasons<br />- quarantined\_reasons<br />See [Array Value Enumerations](https://docs.ivanti.com/rdb/essentials-guide/array-value-enumerations) for more information. |
| os\_version                                 | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| owner                                       | character varying(255)      | No        | No           | Indicates the device’s owner. See [Values for the MI\_DEVICE.owner](https://docs.ivanti.com/rdb/essentials-guide/value-enumerations#datadictionary_175275488_721677) for more information.                                                                                                   |
| pending\_device\_passcode                   | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| pending\_device\_passcode\_expiration\_time | timestamp without time zone | No        | No           |                                                                                                                                                                                                                                                                                              |
| platform                                    | character varying(255)      | No        | No           | Indicates the device’s platform. See [Values for the MI\_DEVICE.platform Field](https://docs.ivanti.com/rdb/essentials-guide/value-enumerations#datadictionary_175275488_721524) for more information.                                                                                       |
| platform\_name                              | character varying(255)      | No        | No           | Indicates the device’s platform name. See [Values for the MI\_DEVICE.platform\_name Field](https://docs.ivanti.com/rdb/essentials-guide/value-enumerations#datadictionary_175275488_721533) for more information.                                                                            |
| processor\_architecture                     | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| quarantined                                 | boolean                     | No        | No           |                                                                                                                                                                                                                                                                                              |
| quarantined\_action                         | bigint                      | No        | No           |                                                                                                                                                                                                                                                                                              |
| quarantined\_reasons                        | character varying(256)      | No        | No           | Describes why the device is quarantined. See the **MI\_DEVICE** fields:<br />- blocked\_reasons<br />- noncompliance\_reasons<br />- quarantined\_reasons<br />See [Array Value Enumerations](https://docs.ivanti.com/rdb/essentials-guide/array-value-enumerations) for more information.   |
| registration\_date                          | timestamp without time zone | No        | No           |                                                                                                                                                                                                                                                                                              |
| registration\_imsi                          | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| registration\_uuid                          | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| retired                                     | boolean                     | No        | No           |                                                                                                                                                                                                                                                                                              |
| roaming                                     | boolean                     | No        | No           |                                                                                                                                                                                                                                                                                              |
| security\_state                             | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |
| serial\_number                              | varchar                     | No        | No           |                                                                                                                                                                                                                                                                                              |
| sd\_card\_encrypted                         | boolean                     | No        | No           | Is the SD card encrypted.                                                                                                                                                                                                                                                                    |
| status                                      | character varying(255)      | No        | No           | Indicates the device’s status. See [Values for the MI\_DEVICE.status Field](https://docs.ivanti.com/rdb/essentials-guide/value-enumerations#datadictionary_175275488_721612) for more information.<br />                                                                                     |
| storage\_capacity                           | bigint                      | No        | No           |                                                                                                                                                                                                                                                                                              |
| storage\_free                               | bigint                      | No        | No           |                                                                                                                                                                                                                                                                                              |
| wifi\_mac\_address                          | character varying(255)      | No        | No           |                                                                                                                                                                                                                                                                                              |

