On a development/test environment today I had to reset all meter readings. Maximo is storing the last readings in a set of fields of the ASSETMETER table and the reading history in the METERREADING table. Here are the SQL statements I have used. delete from meterreading; update assetmeter set lastreading=0, lastreadingdate=null, sincelastrepair=0, sincelastoverhaul=0, sincelastinspect=0, sinceinstall=0, […]
Improved Automation Scripts application
Maximo automation scripts are a very useful tool to implement custom business logic for your customer. After time you may have many scripts to maintain and it may become hard to understand all the logic you have implemented on a specific object. I easy and useful trick I always use is to modify the Automation […]
Special automation scripts .NEW .SAVE .DUPLICATE
I want to share a small trick I have learned from this presentation. It is an undocumented feature of Automation Scripts that will automatically launch a script based on a special naming convention. For example if you want to run a script each time a ASSET object is saved you just have to create an […]
Implement a Refresh List button
We all know IBM Maximo is not a monitoring console and has no auto-refresh feature in the start center or in the applications. However, in some situations, we may need a Refresh button to reload the content of a table in a Maximo application. In this example I have added a button to refresh the […]
How to correctly define a Table Domain
Have you ever wondered what’s the difference between ‘Validation Where Clause’ and ‘List Where Clause’ in the Maximo Table Domain definition dialog? I believe this is one of the most common misused features in Maximo. I have see so many times tables domains defined in the wrong way. Let me show a good example of […]
Maximo escalations demystified (3/3) Monitoring execution
In the two previous posts (first, second) about escalations we have seen what are escalations and how to tune them. In this post will give you some hints bout how to monitor escalation execution.We know that escalations are background tasks to execute actions on a specific set of records. Some of these actions may be […]
Maximo escalations demystified (2/3) Performances and the ‘repeat’ option
In our first Maximo escalations demystified post I have described the general functionality of Escalations. We will now dig into some details that will help you using this powerful feature at its best. The Repeat flag When defining an escalation you always have to create an escalation point and then you can assign actions and […]
The hidden features of Work Logs
Work Logs are a very useful feature in Maximo and Control Desk products to allow users to keep notes of the progress of work. A very nice feature of work logs is that Maximo displays all work logs for the current record an related ones. Lets make an example. If there is a work log […]
Disable automatic asset/location population in Work Order and Ticket applications
Maximo has a feature that automatically populates the asset when a user enters a location and viceversa. This is a feature may be useful for most clients but some other clients don’t like this behavior. Unfortunately Maximo does not have a built in switch to disable this. The best solution to solve the problem is […]
How to extract emails to notify users
There are several situation where you need to quickly notify a set of users sending them an email. These are few examples of such situations. There is a urgent maintenance activity to perform on Maximo that requires to enable the admin mode and logoff all the users. You are going to rollout an additional validation […]