IBM Maximo consultant, geek, agile evangelist
Many customers I work with use a procedure like this one to clone Maximo environments between production, test and development environments. When you use such techniques, you may quickly screw up some settings used during installation of Maximo fixpacks and upgrades.Here are some important things to check before installing any release, fixpack or add-on. Maximo […]
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 […]
Few times I have found a small but annoying issue on Maximo when attaching Office 2007 files. Do you know those Excel, Word, PowerPoint files with xlsx, docx, pptx extensions? Yes, those! If you are using Microsoft Internet Explorer it may happen that these files can be uploaded successfully into your DOCLINKS folder but when you try […]
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 Maximo Java Development series. In this post I have explained how to query and fetch MBOs from the database. In this small article I will show how to get and set the attributes of an Mbo. How to read attributes To read the attributes of an Mbo you can […]
This entry is part of the Maximo Java Development series. To query a Maximo table using Java you need to perform the following steps: Get a reference to the MboSet. Specify a where clause. Loop through the MboSet and fetch Mbos. The following example shows how to retrieve all the assets located in BEDFORD site. […]
Today I want to share with you all a very efficient technique that I use to test email notifications and communication templates in workflows. The technique is based on a very lightweight dummy SMTP server called smtp4dev that can run on any Windows system. This small application sits in the system tray and does not […]
This entry is part of the Maximo Java Development series. When you are in an Mbo class or you already have a reference to an Mbo object is it possible to retrieve the related records using Maximo object relationships as defined in the Database Configuration application.For example the ASSET object has a relationship called ACTIVEASSETMETER to the […]
This entry is part of the Maximo Java Development series. One of the biggest issues when implementing Java customizations in the Maximo Business Objects layer is to know what is the best method to override to achieve a specific goal.Here I have listed the most common usages of the the main methods in Mbo, MboSet and […]