How to Find Public Works Assets Missing a Scheduled Inspection Record
The monthly report lists completed inspections. It cannot show whether every scheduled asset appears in the file. Start with the schedule and match each expected inspection to a record.
What to pull
Use Excel asset, schedule and completion tabs or export the register and inspection history from asset management software. Keep asset ID, inspection type, due date and result status.
How to check it
Match by asset, inspection type and due window. Separate missing completion records, incomplete paperwork and approved deferrals. Retain retired assets for a status check.
Select the relevant sheets in Jolene.pro and run this check.
Which scheduled inspections lack a qualifying completed record? Show due dates, exceptions and source rows.
What to do with the result
Give each inspection owner the asset IDs and outstanding records. Verify field paperwork before rescheduling or closing an item.
Follow the agency’s official inspection rules and verify the system of record.