Abstract There has been considerable research into prediction of water mains failure, however, those models are very complex and fail to convey the message of the health status of an asset to the relevant stakeholders. The study developed a ‘pipe health scorecard’ based on historical failure data which could be used for operation, maintenance, refurbishment, or replacement decisions by a water utility. This scorecard model was developed by using 160,413 pipe-condition data sets from the South Australian Water Corporation over ten years. Measures such as the Kolmogorov–Smirnov (KS) statistic, Area Under the ROC Curve (AUC), and Population Stability Index (PSI) showed the model is strong enough to predict the health status of water mains. The study found the factors influencing water mains failure to be in the order of importance: length, material, age, location (road vs verge), diameter, and operating parameters. The development of a simple but reliable model for the assessment of the health status of water mains will have major benefits to the water utility with the ability to identify and potentially replace water pipes prior to failure. Additional benefits of flexible scheduling of maintenance and replacement programs would contribute to cost savings.