How to extract failure codes, problems, causes and remedies
How to extract failure codes, problems, causes and remedies
January 11, 2013
Today a customer asked me to extract the full listing of failure codes, problems, causes and remedies. He wants to be able to create an Excel spreadsheet to analyze the failure codes tree in order to improve and reorganize such structure.
Here is the SQL query that can extract this information from Maximo database.
select f.failurecode failureclass, p.failurecode problem, c.failurecode cause, r.failurecode remedyfrom failurelist fleft outer join failurelist p on p.parent=f.failurelist and p.type='PROBLEM'left outer join failurelist c on c.parent=p.failurelist and c.type='CAUSE'left outer join failurelist r on r.parent=c.failurelist and r.type='REMEDY'where f.parent is nullorder by f.failurecode, p.failurecode, c.failurecode, r.failurecode;If you need to import failure codes hierarchy you may take a look at this article.