IBM Maximo consultant, geek, agile evangelist
One of the first thing I always say to the new hires that are going to learn Maximo is how much important is to have a good knowledge of SQL language. It is really important to build application queries, Birt reports, database relationships, complex table domains, conditional expressions and many other Maximo configurations. The important […]
Maximo has a well known feature to display the history of where an asset was located. It is accessible from View Asset Move History from the Asset application.In the following example the asset DS01-A-002 was created in location DS01-S-SA-01 and then moved to other two locations. The data displayed in this dialog is stored in the ASSETTRANS […]
Many times Maximo users and administrator lacks database skills. These are important in several situations: Write ‘where clause’ statements to filter data in Maximo UI. Develop complex SELECT statements to extract data from multiple tables when developing report. Optimize existing queries to solve performance issues. If you need to improve your SQL skills I suggest […]
The following SQL query lists all the security groups and the associated users. SELECT maxgroup.groupname, maxgroup.description, maxuser.userid, maxuser.loginid, maxuser.defsiteFROM maxgroupJOIN groupuser ON groupuser.groupname=maxgroup.groupnameJOIN maxuser ON maxuser.userid=groupuser.useridORDER BY maxgroup.groupname, maxuser.userid; The best approach to analyze the results is to load them into Excel and create a pivot table.
You have probably noticed that once you have saved an object you are not allowed to change it’s ID. This is basically because each object stored on the database needs an immutable unique identifier that can be used to reference that object from other tables. Maximo prevents updating such identifiers to avoid loosing links between […]
Roles in Maximo are used to represent a specific person or a group of people that can be used in workflows, communication templates and escalations. If you need to find which roles are used in a specific workflow you can use an SQL query like this. SELECT wfnode.title, wfnode.description, wfa.roleid, r.descriptionFROM wfnodeJOIN wfassignment wfa ON […]
My job brings me across Europe to meet many different customers and work with a vast variety of Maximo environments. One of the most important tasks is to be able to quickly assess a Maximo environment that I have never seen before. How much data? One of the tools I use is a set of […]
Before Maximo 6 it was a common practice to implement customizations using database triggers. Although Conditional Expressions, SigOptions, Java coding and scripting are now available in Maximo 7, I still see many Maximo environments with a lot of database triggers.In a recent project I have found a Maximo system with more than 30 triggers and […]
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 […]
This entry is part of the Java MBO performance optimization golden rules series. Sometimes you have to perform some complex logic or you have to join several tables to retrieve a piece of data. In other cases there is a piece of code where performance is critical. In such cases it may be hard to […]