Sometime you have a complex workflow with many nodes. In these situations is not always easy to troubleshoot an issue or to modify the workflow for a changing business need. For example we may have several nodes in the workflow setting the work order status to CANC. We know that we use the WO CANC […]
Understanding People, User, Labor, Craft, etc.
Maximo has several interrelated objects People, Person Group, Users, Labor, Craft, Qualifications, etc. Sometimes is difficult to understand the real differences between them. In this post I will provide a quick overview of these concepts. For more details you can refer to this excellent Maximo Secrets application Map. People A person record contains basic information […]
Personal email signature in Communication Template
A very useful feature of Maximo is the ability to send emails to recipients from many applications like Work Order Tracking or Service Requests. The Create Communication action can be used to fill the email data (To, CC, BCC, Subject, Message , attachments). In this context it is very useful to have define Communication Templates […]
Maximo escalations demystified (1/3)
Escalations are one of the most common (and easiest) way we use to automate actions in Maximo. They are well known by Maximo specialists but there are some tips to better use them and some undocumented feature you may like to use. The simplest definition of an escalation is the following. An escalation is a […]
How to restrict allowed status changes for workorders
Maximo has a predefined set of statuses for work orders that are defined in the WOSTATUS synonym domain. The values and their meaning are well documented in the official documentation. Unfortunately the allowed state transitions are hardcoded in the psdi.app.workorder.WOStatusHandler class and cannot be easily changed since they are defined as private arrays. Here is a brief […]
Maximo keyboard shortcuts
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 operators
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 […]
Find inactive users in Maximo
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
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 […]
Improving Assets and Locations drilldown dialog
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 […]