Common device fields: MI_DEVICE table
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:
See 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:
See 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 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 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 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:
See 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 for more information. |
storage_capacity | bigint | No | No | |
storage_free | bigint | No | No | |
wifi_mac_address | character varying(255) | No | No | |
