iOS and OS X device fields: MI_DEVICE_IOS table
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 | |
