I would recommend to add an exception rule for the Aux in question. The system would create an event when the Aux is on and then continue that event until the Aux is no longer valid. The events would provide the required information. This way one would not need retrieving GPS records for a period of time to estimate Aux duration..
Please provide the best way (lowest bandwidth, least amount of time) to calculate the Aux times with a given device, fromDate, and toDate.
Unless I am missing something, the only way I can do it is to examine every single log over the period of time one by one using my own logic. The period of time could be up to 2 or 3 weeks.
Please sign in to leave a comment.