Maximo

Reset all meter readings

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, […]

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 […]

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) […]

Scroll to top