Stores device hardware information
Data model
Fields
| Field | Type | Description |
|---|---|---|
| devh_availableexternalstorage | BIGINT | External storage available |
| devh_availableinternalstorage* | BIGINT | Internal storage available |
| devh_availablerammemory | BIGINT | Available RAM |
| devh_batteryhealth | NVARCHAR (60) | Battery Health |
| devh_batterylevel* | REAL | Battery Level |
| devh_batterytechnology | NVARCHAR (60) | Battery Technology |
| devh_batterytemperature | NVARCHAR (40) | Battery temperature |
| devh_batteryvoltage | NVARCHAR (40) | Battery voltage |
| devh_buildversion | NVARCHAR (256) | Device build version |
| devh_cellulartechnology | NVARCHAR (32) | Cellular Technology |
| devh_cpucores | NVARCHAR (30) | CPU cores |
| devh_cpufrequency | NVARCHAR (50) | CPU Frequency |
| devh_cpuname | NVARCHAR (200) | CPU Name |
| devh_devicelanguage | NVARCHAR (64) | Device language |
| devh_devicelocaltime | DATETIME | Device Local Time |
| devh_devicemanufacturer | NVARCHAR (128) | Device Manufacturer |
| devh_devicename | NVARCHAR (256) | Device Name |
| devh_devicetype | INT | Device Type |
| devh_firmwareversion | NVARCHAR (128) | Device firmware version |
| devh_id* | INT | Unique device hardware identifier |
| devh_imei | NVARCHAR (128) | International Mobile Equipment Identity (IMEI) |
| devh_isrooted | BIT | Indicates if the device is rooted |
| devh_locationavailable | BIT | Available Location |
| devh_meid | NVARCHAR (128) | Mobile Equipment Identifier (MEID) |
| devh_modelname | NVARCHAR (128) | Device Model Name |
| devh_modelnumber | NVARCHAR (64) | Model Number |
| devh_osversion | NVARCHAR (64) | Operating System Version |
| devh_phonenumber | NVARCHAR (64) | Device phone number |
| devh_processorarchitecture | NVARCHAR (128) | Processor architecture |
| devh_productname | NVARCHAR (128) | Product Name |
| devh_screenresolution | NVARCHAR (50) | Screen Resolution |
| devh_screensize | NVARCHAR (40) | Screen size |
| devh_sensors | NVARCHAR (4096) | Device sensors |
| devh_serialnumber | NVARCHAR (128) | Serial Number |
| devh_simserialnumber | NVARCHAR (128) | SIM serial number |
| devh_totalexternalstorage | BIGINT | Total external storage |
| devh_totalinternalstorage* | BIGINT | Total internal storage |
| devh_totalrammemory | BIGINT | Total RAM |
| devh_udid | NVARCHAR (256) | Unique Device Identifier (UDID) |
Primary Key
| PK_AMDMDEVICEHARDWARE |
|---|
| devh_id |