SonnetDB for VS Code

⌘factory-overview.sql — SonnetDB▢　—　□　×

factory-cluster › factory › query › factory-overview.sql

1
2
3
4
5
6
7

SELECT time, deviceId, temperature, pressure
FROM device_metrics
WHERE time > now() - interval '1 hour'
  AND lineId = 'LINE-1'
ORDER BY time DESC
LIMIT 100;

time	deviceId	temperature	pressure	status
14:31:48.123	PLC-101	56.7	1.21	OK
14:31:46.987	PLC-102	48.1	1.08	OK
14:31:44.876	SENSOR-77	42.8	1.14	WARN