Devices with no recent activity
SQL query for TraxGo
Get a list of devices that have not sent any positions in the last 24 hours.
SELECT * FROM Devices WHERE last_position_timestamp < NOW() - INTERVAL 1 DAY;
TraxGo data model
Devices
Latest Positions
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed