IBM Maximo consultant, geek, agile evangelist
I have just implemented the capability to upload attachments straight from MxLoader. This is in response to some requests on my blog and MxLoader support forum. Starting from Maximo 7.1.1.6 it is possible to import attachments to an object through MIF using Base64 encoding.MxLoader has the capability to read files from the filesystem, encode them […]
We all know Maximo is a complex product. It has plenty of features and is very flexible but sometimes complex to manage especially when system performances are poor.A lot of things may affect the perceived performances of Maximo and it may be hard to have an overview of the entire system configuration. What are the […]
This entry is part of the Maximo Integration Framework series. Update April 2021 – This post describes the old REST APIs. A tutorial on the new APIs can be found here. In this tutorial I will show how easy it is to query and update data in Maximo using the Integration Framework (MIF) REST interface. […]
Loading failure codes is not currently supported on MxLoader NextGen. Download MxLoader 6.2 (legacy). Creating and maintaining the hierarchy of failure codes in Maximo can be quite long and boring task using the standard Failure Codes application. The easiest and fastest way of importing Failure codes and the corresponding hierarchy is using MxLoader. The example […]
You know IBM Maximo has a lot of fields and sometimes can be boring entering data. Here are some keyboard shortcuts that can ease the pain. I have highlighted in bold the most common and useful ones. Tab > The most important keyboard shortcut is the TAB key. It allows you to move across fields […]
Maximo search features are quite advanced but often neglected. By using the advanced search techniques described in this post it is possible to find relevant records easier and faster. Equal The equal ‘=’ operator can be used to find only records that match that a word or number exactly. In other words ‘=’ means “exact […]
Here is a quick SQL query you can use to find inactive users that haven’t logged into Maximo in the last 2 months. DB2 select * from maxuserwhere status=’ACTIVE’and sysuser=0and not exists (select userid from logintracking where logintracking.userid=maxuser.userid and attemptresult=’LOGIN’ and attemptdate>(current date-60 DAYS))order by userid; Oracle select * from maxuserwhere status=’ACTIVE’and sysuser=0and not exists […]
Long descriptions in Maximo are a special fields meant to store long text. Unlike all the other fields they are stored in a dedicated table called LONGDESCRIPTION. Tables link to the LONGDESCRIPTION table through their unique ID and the long description attribute is stored in a CLOB field. Let’s change the long description of the work […]
The Assets/Locations drilldown dialog is one of the most longstanding and criticized features of Maximo. This dialog is almost unchanged from release 6.1 and definitely lacks some important capabilities to provide a unified view of assets and location hierarchy. However, we can make few minor improvements to the standard dialog to make it slightly better. Increase […]
A common requirement in Maximo is to track changes made by users on a specific object (database table). In Maximo terms this is called ‘Audit Tracking’.In this post I will describe how to enable audit tracking for a specific set of attributes of an object and how to display the updates in a separate tab […]