Windows Phone and Surface Device fields:
MI_DEVICE_WINDOWS_PHONE table
The set of Windows Phone and Surface-only device fields in the MI_DEVICE_WINDOWS_PHONE table comprises Windows Phone and Surface-specific device details. It has a one-or-zero to one relationship with the MI_DEVICE table. If a device is not a Windows Phone or Surface device, the record will not be here.
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 |
|
dm_client_version |
double precision |
No |
No |
|
wp_cert_renew_timestamp |
timestamp without time zone |
No |
No |
|
wp_ent_dm_id |
bigint |
No |
No |
|
wp_exchange_id |
character varying(255) |
No |
No |
|
wp_firmware_version |
character varying(255) |
No |
No |
|
wp_hardware_version |
character varying(255) |
No |
No |
|
wp_local_time |
timestamp without time zone |
No |
No |
|
wp_processor_type |
bigint |
No |
No |
|
wp_signed_ent_dm_id |
bigint |
No |
No |
|