IBM Maximo consultant, geek, agile evangelist
Some days ago I came across this interesting post from Pam Denny that describes the 80/20 rule. Based on this empirical rule 80% of the report processing is done by only 20% of used reports.That’s why I developed a simple SQL query that uses the LASTRUNDURATION field of the REPORT table to list the report […]
This entry is part of the Conditional Expressions HowTo. Here is a step-by-step guide about how to dynamically highlight workorders that have a high priority in the WOTRACK application. This is just an example and the same configuration can be used to change the color of a field based on a particular condition. Define conditional […]
Did you have ever spent precious time searching in the Group Security application what group grants a specific permission to a certain user?Do you want to list all the sigoption granted to a specific user?Do you want to list all the groups to which a specific user belongs together with all the granted sigoptions?Do you […]
This entry is part of the Maximo Java Development series. In this article I will describe some common ways of iterating through an MboSet and what is the best approach.In the following examples mboSet is the already holding the MboSetRemote that you need to traverse. Example 1 (worst solution) for(int i=0; i<mboSet.count(); i++;){ MboRemote currMbo=mboSet.getMbo(i); […]
This article explains a procedure that can be used to migrate the Maximo 7.1 Administrative Workstation from one physical system to another. Installation of products based on Maximo/TPAE infractructure (MAM, TAMIT, CCMDB, etc.), industry specific extension (Nuclear, Transportation, etc.) or fixpacks use the IBM Autonomic Deployment Engine. This is installed at the beginning of the […]
This post describes how to set an object attribute as mandatory without providing a default value. This is to circumvent what it seems to be a TPAE limitation that prevents to do this from the standard Database Configuration application.Lets make an example. The out-of-the-box attribute PO.VENDOR (Purchase Order – Vendor) is not mandatory. Unfortunately if […]
In version 7.5 of Maximo/TPAE products, you can import and export data from applications. Learn how to enable this feature in this unofficial guide.There is also a nice TechNote from IBM.
An interesting feature of Maximo crontask is the capability of storing the task execution times. This feature must be enabled in each crontask clicking on ‘Keep history’ checkbox. This is nice feature but Maximo does not provide a graphical tool to analyze crontask performances and execution times so i have prepared a small set of […]
In this post I will show how to enable the lookup functionality for selecting one or multiple values in a report parameter.Instead of creating a new lookup I will show all the necessary configurations looking at the built-in report ‘Inventory Balance’ (inventory_balance_tbl.rptdesign). Enabling lookup in report Open the ‘Report Administration’ application and search for ‘Inventory […]
The standard Maximo ‘Security Groups’ application provides an easy way to view and modify users access to applications. However it is not always easy to have an overview of what groups are granted to access a specific application or what applications can be accessed by a specific group.With the following SQL query you can get […]