IBM Maximo consultant, geek, agile evangelist
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 […]
Eclipse Kura is an Open Source project that provides a platform for building IoT gateways. It is a smart application container that enables remote management of such gateways and provides a wide range of APIs for allowing you to write and deploy your own IoT application. Kura runs on top of the Java Virtual Machine […]
In this post I will describe how to install the Raspbian operating system on a Raspberry PI 2 or 3 and some basic configuration settings to start your IoT projects.The described procedure will not require a display and keyyboard and can be performed just connecting the PI to your router using a LAN cable. Raspbian […]
By default MxLoader uses plain Object Services through HTTP calls. These services are automatically exposed when an Object Structure is created in Maximo. Using Web Services is possible to have more control over data defining processing classes, user exit classes, XSL maps, and processing rules. MxLoader 5.1 now allows to use Web Services as well. […]
A common need is to differentiate Maximo production, test, development environments.The easiest technique I know is to customize the login and header messages.Open Database Administration application and select the Messages action. Search for ‘welcome’ and change the messages in the ‘login’ group as you wish. The welcome message is displayed on the login page, the […]
Maximo 7.6 has a lot of interesting features. One of these is the new installation technology.Richard Lesses has published a useful set of articles with a step-by-step guide of how to install Maximo 7.6. Installing Maximo 7.6: A first look, part 1Installing Maximo 7.6: A first look, part 2Installing Maximo 7.6: A first look, part […]