MS SQL
i think you can calculate it based on motion speed & ignition and also use some threshold periods that avoid the traffic.
i think you can calculate it based on motion speed & ignition and also use some threshold periods that avoid the traffic.
Can someone help me with the logic of how to define a query that would calculate the idle time for a specific date for all devices.
I got some results but they don't match the traccar report.
Thank you