device_info_view (view)

35,362 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: serial_number, device_type, manufacturer, product, battery_status, timestamp (date)

Next page

CREATE VIEW device_info_view AS SELECT device_info.timestamp AS timestamp, device_info.file_id AS file_id, device_info.serial_number AS serial_number, devices.device_type AS device_type, device_info.software_version AS software_version, devices.manufacturer AS manufacturer, devices.product AS product, devices.hardware_version AS hardware_version, device_info.battery_status AS battery_status 
FROM device_info JOIN devices ON devices.serial_number = device_info.serial_number ORDER BY device_info.timestamp DESC;