IBM Maximo consultant, geek, agile evangelist
The following SQL query lists all the security groups and the associated users. SELECT maxgroup.groupname, maxgroup.description, maxuser.userid, maxuser.loginid, maxuser.defsiteFROM maxgroupJOIN groupuser ON groupuser.groupname=maxgroup.groupnameJOIN maxuser ON maxuser.userid=groupuser.useridORDER BY maxgroup.groupname, maxuser.userid; The best approach to analyze the results is to load them into Excel and create a pivot table.
Users that heavily rely on StartCenters to check for incoming tickets or work orders sometimes ask if the StartCenter can automatically refresh itself. To accomplish this you can inject a small JavaScript into the StartCenter JSP code.Backup the following file and open it with a text editor: [SMPDIR]\maximo\applications\maximo\maximouiweb\webmodule\webclient\components\startcenter-options.jsp Search for a row like this <table […]
One of the customer that I’m working with is heavily relying on work logs. Unfortunately, the work logs are displayed in a standard table so there is no way of quickly displaying all the logs entered by the users. The solution I have designed is a QuickSummary tab in the Work Order Tracking application that […]
Using Maximo search functionality can be sometimes complex or even frustrating. Several customers have asked me if there is a simple Google-like functionality to search for all the objects that contains a specific set of words. This article describes how to implement such feature in the Work Order Tracking application. The solution described in this […]
NOTE: This techniques requires Java programming. A similar article describes how to achieve the same results with scripting. One of the customer that I’m working with is heavily relying on work logs. Unfortunately, the work logs are displayed in a standard table so there is no way of quickly displaying all the logs entered by […]
This entry is part of the Maximo Java Development series. Many objects in Maximo has a STATUS attribute that can be changed using the status icon or the change status menu option. The STATUS attribute is always associated with a synonym domain that has the valid statuses for the object. Examples of these domains are: […]
When implementing business logic in Java code it may be useful to compare the value of an attribute to it’s previous or initial value.This is particularly useful when overriding MboValueAdapter.action() method to validate the new value of an attribute as soon as it changes. Look at how the three values are retrieved in the following […]
Checkout the updated MaximoDev stats. MaximoDev Facts and Stats (September 2013) from Bruno Portaluri
Sometimes is a bit hard to find an exact list of system requirements and prerequisites for IBM Maximo and SmartCloud Control Desk (SCCD) products. If you want to know what are the supported operating systems and middleware versions here are the most important sources of information: IBM SmartCloud Control Desk system requirements IBM Maximo system […]
Translated messages and labels are not enabled by default on Maximo workflows. This means that if you have a multilanguage environment all the users will see the same task descriptions interaction messages when using workflows.To be able to insert translated labels and messages for workflows you have to enable the multi-language option for the following […]