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, […]
Modify Asset’s condition code from Work Order
Condition codes are used in Maximo to define various physical states of a particular item. Once the condition code of an asset is set, it becomes readonly and can only be modified using the Move/Modify Asset menu option found in the Select Action menu of the Assets application (link). In some cases it makes sense […]
Loading Item Assembly Structures (IAS) with MxLoader
I have just releases version 6.2 of MxLoader that contains a brand new template for loading Loading Item Assembly Structures (IAS) into Maximo. An item assembly structure is a list of spare parts and subassemblies required to build an Asset or to define the requirements of a location. Starting from this IBM technote I have […]
Ensure Asset’s serial number uniqueness
Sometimes you need to ensure the uniqueness of a certain database column in the Maximo database. A common example of this scenario is to ensure that asset’s serial numbers are not duplicated. This can prevent the creation of duplicate assets. In this post I describe two techniques to achieve this using a unique database index […]
Send Work Order Calendar invitations
In this article I will show how to send calendar invitations to workers with work order details and reminders for the activities. The calendar event can have a link to Maximo in order to report progress or close the work order using the standard Everyplace or Work Centers interface.
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 […]
Maximo Scripting – Library Scripts
This post is an excerpt from the Maximo 76 Scripting Features guide. Library scripts are good for encapsulating some re-usable logic. In Maximo 7.6, we can write library scripts as just simple scripts. We can write these scripts in any language and then call from another language. Lets make a library script for making HTTP […]
Service object methods in automation scripts
The service object has been added in Maximo 7.6 script and is very useful in several scenarios. Here is a list of available methods. For more details refer to this page. Logging getLogger(loggerName) log_debug(logMsg) log_debug(logMsg, java.lang.Throwable t) log_error(logMsg) log_error(logMsg, java.lang.Throwable t) log_fatal(logMsg) log_fatal(logMsg, java.lang.Throwable t) log_info(logMsg) log_info(logMsg, java.lang.Throwable t) log_warn(logMsg) log_warn(logMsg, java.lang.Throwable t) log(logMsg) logError(logMsg) […]
Maximo 7.6 Scripting
Maximo 76 Scripting Features guide is a great source of information but it has been released only in PDF format so it’s poorly indexed by Google. I have split it in small articles and shared here in order to be easily searched over the internet. Library Scripts Warnings and Errors Yes/No/Cancel dialog Before Save, After […]
Maximo Scripting – MMI
This post is an excerpt from the Maximo 76 Scripting Features guide. Maximo Management Interface provides a set of apis (REST/JSON apis) that helps a system administrator gets some insights on the state of the maximo runtime. The root url for that api is: GET /maximo/oslc And then you can dive deeper into each server […]