---
title: iOS and OS X device fields: MI_DEVICE_IOS table
slug: rdb/essentials-guide/ios-and-os-x-device-fields-mideviceios-table
createdAt: 2026-11-05T09:24:41.960Z
---

The set of iOS and OS X device fields in the MI\_DEVICE\_IOS table comprises iOS and OS X device details. It has a one-or-zero to one relationship with the MI\_DEVICE table. If a device is not an iOS device, the record will not be here.

Table: iOS and OS X device fields

| Name                                    | Data type                   | Not Null? | Primary key? | Description                                                                                                  |
| --------------------------------------- | --------------------------- | --------- | ------------ | ------------------------------------------------------------------------------------------------------------ |
| apns\_token                             | character varying(255)      | No        | No           |                                                                                                              |
| bluetooth\_mac                          | character varying(255)      | No        | No           |                                                                                                              |
| build\_version                          | character varying(255)      | No        | No           |                                                                                                              |
| carrier\_settings\_version              | character varying(255)      | No        | No           |                                                                                                              |
| current\_mcc                            | character varying(255)      | No        | No           |                                                                                                              |
| current\_mnc                            | character varying(255)      | No        | No           |                                                                                                              |
| data\_roaming\_enabled                  | boolean                     | 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\_name                            | character varying(255)      | No        | No           |                                                                                                              |
| device\_uuid                            | character varying(64)       | No        | No           |                                                                                                              |
| etl\_run\_ts                            | timestamp without time zone | Yes       | No           | The time the snapshot is taken on VSP.                                                                       |
| FDEncryption\_Enabled                   | boolean                     | No        | No           | Is full disk encryption enabled.                                                                             |
| FDEncryption\_InstitutionalRecoveryKey  | boolean                     | No        | No           | Does full disk encryption have institutional recovery key.                                                   |
| FDEncryption\_PersonalRecoveryKey       | boolean                     | No        | No           | Does full disk encryption have personal recovery key.                                                        |
| force\_encrypted\_backup                | boolean                     | No        | No           |                                                                                                              |
| hardware\_encryption\_caps              | bigint                      | No        | No           |                                                                                                              |
| ios\_background\_status                 | bigint                      | No        | No           |                                                                                                              |
| ip\_address                             | character varying(255)      | No        | No           |                                                                                                              |
| iphone\_iccid                           | character varying(255)      | No        | No           |                                                                                                              |
| iphone\_mac\_address\_en0               | character varying(255)      | No        | No           |                                                                                                              |
| iphone\_product                         | character varying(255)      | No        | No           |                                                                                                              |
| iphone\_udid                            | character varying(255)      | No        | No           |                                                                                                              |
| iphone\_version                         | character varying(255)      | No        | No           |                                                                                                              |
| is\_mdm\_lost\_mode\_enabled            | varchar                     | no        | no           |                                                                                                              |
| is\_mdm\_service\_enrolled\_device      | varchar                     | no        | no           |                                                                                                              |
| it\_policy\_result                      | bigint                      | No        | No           |                                                                                                              |
| Last\_Acknowledged\_Lock\_PIN           | string                      | no        | no           | Last acknowledged lock PIN                                                                                   |
| Last\_Acknowledged\_Wipe\_PIN           | string                      | no        | no           | Last acknowledged wipe PIN                                                                                   |
| modem\_firmware\_version                | character varying(255)      | No        | No           |                                                                                                              |
| Organization\_Info                      | string                      | no        | no           | Organization information                                                                                     |
| os\_update\_status                      | varchar                     | no        | no           |                                                                                                              |
| OSX\_UserID                             | string                      | no        | no           | OS X user ID                                                                                                 |
| OSX\_UserLongName                       | string                      | no        | no           | OS X users’ long name                                                                                        |
| OSX\_UserShortName                      | string                      | no        | no           | OS X user’s short name                                                                                       |
| passcode\_is\_compliant                 | boolean                     | No        | No           |                                                                                                              |
| passcode\_is\_compliant\_with\_profiles | boolean                     | No        | No           |                                                                                                              |
| passcode\_present                       | boolean                     | No        | No           |                                                                                                              |
| PersonalHotspotEnabled                  | boolean                     | No        | No           | Is the personal hotspot enabled.                                                                             |
| product\_name                           | character varying(255)      | No        | No           |                                                                                                              |
| security\_reason\_code                  | character varying(255)      | No        | No           |                                                                                                              |
| serial\_number                          | character varying(255)      | No        | No           |                                                                                                              |
| signal\_strength                        | bigint                      | No        | No           |                                                                                                              |
| sim\_carrier\_network                   | character varying(255)      | No        | No           |                                                                                                              |
| sim\_mcc                                | character varying(255)      | No        | No           |                                                                                                              |
| sim\_mnc                                | character varying(255)      | No        | No           |                                                                                                              |
| subscriber\_carrier\_network            | character varying(255)      | No        | No           |                                                                                                              |
| supervised                              | boolean                     | No        | No           |                                                                                                              |
| voice\_roaming\_enabled                 | boolean                     | No        | No           |                                                                                                              |
| vpn\_ip\_address                        | character varying(255)      | No        | No           |                                                                                                              |
| vsp\_id                                 | integer                     | No        | No           |                                                                                                              |

