How to Track Water Utility Work Orders That Keep Reopening
A valve appears in three closed work orders and a new call this month. Maintenance needs to tell which entries are separate failures and which are follow-ups.
What to pull
Use Excel work orders and asset history, or export completed orders from maintenance software and asset IDs from the asset register. Keep parent work order, problem code and service dates.
How to check it
Group by asset ID and issue. Tie reopened jobs and follow-up visits to the original event. Keep ambiguous address-only matches separate.
Which assets had two or more distinct work orders for the same issue this quarter? Show dates, recorded causes and source rows.
What to do with the result
Review the oldest unresolved repeat first, then pass the asset history to maintenance planning for investigation.
Treat the results as a planning list and follow your utility’s procedures for maintenance decisions.