Why audit tracking devices and cameras?
A device can stop working without anyone noticing. The vehicle drives, the driver sees nothing wrong, and the platform simply shows an old position. The same is true for a camera lens covered in dust or an SD card that stopped recording. You find out after an incident, when the footage is not there.
A periodic audit finds these before they matter. It also leaves a dated record that you checked.
How to use the sheet
- Check the Settings sheet. Change the quiet-period limit, the audit interval and the repair limit to your policy.
- Read the last report time from your platform. Do it just before you inspect the device.
- Answer all ten checks. Use N/A for a part the device does not have. A blank check makes the row Incomplete.
- Copy findings to the Actions sheet. Name who is responsible and a due date for each one. The sheet marks it Overdue when the date passes.
- Read the Summary. It counts healthy, action needed and repair or replace, and shows which check fails most.
How the status is decided
Repair or replace if failed checks >= the repair limit
Action needed if any check is Check or Fail
Healthy otherwise72 h quiet, limit 24 h x 3 = CheckLast report: up to the limit is OK, up to the limit times the multiplier is Check, longer is Fail.
Your technician makes the final decision. The status is a suggestion that makes sure nothing is skipped.
How often should you audit?
Many fleets audit every 6 to 12 months, and more often for devices on critical contracts. This is a common practice, not a rule from any client or regulator. Set the interval that fits your risk and your contract, and verify it against your client's current text.
Audit while the vehicle is in the depot for another reason, such as a service. It takes minutes per device.
Limits of this sheet
It records and decides a status. It does not read a device, does not know what a healthy voltage is for your model, and does not fix anything. Take healthy values from your device datasheet.