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 remedy from failurelist f left 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 null order 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.
thanks bruno
ReplyDeleteThis is great but I need it to also bring in the descriptions for all four columns.
ReplyDeleteI am also looking for a way to query work orders for all of the failure codes so that I can start drilling down on what the problem assets are.