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.
| 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 |
|