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