beginner

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

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

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

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

Scroll to top