Maximo

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

MxLoader now supports Web Services

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

Display bullettin board messages opened by default

A common requirement is to display the bulletin board messages in a more visible way.A simple solution is to display the formatted message opened by default. To achieve this you can edit the following JSP file: [SMP]\applications\maximo\maximouiweb\webmodule\webclient\components\bulletinboard.jsp On my Maximo 7.5.0.6 i have this line of code at row 335: style=”display:none;overflow:visible” If you change the […]

Remove the 200 record limit in Anywhere simulator

The mobile app simulator is a great tool when developing mobile applications with Maximo Anywhere. Obviously it does not replace a good test on the real device but it is essential during development especially when the browser development tools are used to inspect and debug the app.One limitation of the simulator is the 200 records […]

Scroll to top