Maximo® Tips
Maximo Tips are submitted by users like you and vary between Maximo versions 4, 5, 6, and 7. Anyone can submit a tip by emailing it to info@projetech.com . The tip that you submit will be reviewed by a circulating panel of judges here at Projetech. A new winner is chosen and that tip is then published on this website.
The winner will be mailed a $100 American Express Gift Card. All tips are considered each time – there is no need to resubmit a tip. Please include which version of Maximo and which database platform you are using.
Best of luck!
Our Latest Free Maximo Tip
This tip is from an anonymous reader and deals with filtering Work Orders in Maximo 6:
If you wanted to find work orders with 'pump' or 'conveyor' in the description, it would be:
WHERE ((upper(description) like '%PUMP%' or upper(description) like '%CONVEYOR%') and historyflag = 'N' and istask = 'N')
If on the other hand, you wanted to exclude 'pump' and 'conveyor', then you would have:
WHERE ((upper(description) not like '%PUMP%' and upper(description) not like '%CONVEYOR%') and historyflag = 'N' and istask = 'N')
So, the things to keep a handle on are where the 'not' goes, and the use of 'and' for all the words you wish to exclude.
Think you've got a better tip? Send as many as you can think of to us at info@projetech.com and you could be our next winner!
Take a minute or two to check out past tips that Projetech has already published, and you might save yourself hours—or days!
Submitted anonymously :
This is how to add fields into the advanced search in Maximo v. 6.2.
From within Application Designer, choose the application you wish to edit (e.g. wotrack).
While editing the application, click on the icon for 'Edit Dialogs' (just left of the Delete (Red 'X) button)
Navigate down to and choose the controlid 'searchmore' and the Advanced Search dialog will open for normal editing, like an application tab. Add extra, and/or other fields, move them around, remove them, leverage domain/valuelist available, etc.
Submitted anonymously :
There is a limitation of 50 records on any level in the Drilldown display. If there are more than 50 records to display, there is a message in the 51st position that tells you of the limitation. I found instructions on how to reset the value to allow for more records to be displayed.
http://www-01.ibm.com/support/docview.wss?uid=swg21381616The instructions require that the change be accomplished in the Maximo\Applications\Maximo\Properties folder.
Submitted anonymously:
To stop query creation by application/user group, you need to alter security for each group in question.
Go to security groups, and select a group. Click on the applications tab. Scroll down to Work Order Tracking, or the application of your choice. If the user has rights to save, then you need to go to the bottom half of the screen and scroll to 'Save Current Query'. Make sure the box is unchecked, and that group can no longer save a query. Repeat this for each application / group combination you wish to alter.
Submitted anonymously:
This tip is a query to view system/error messages in Maximo 7.1 :
When working in Maximo there are system/error messages generated at different points. These have the form “BMXAA3555E – The request page for the report has not been generated.” These ‘BMX’ messages are stored in the Maximo database. To retrieve the messages or to see all generated messages this query can be used: (replace ‘report’ with the name of the report generating the message).
Select *
From MAXMESSAGES
Where msggroup LIKE ‘report%’
Submitted anonymously:
This tip is a helpful link for Maximo ITAM users.
What are some ‘Best Practices’ used in asset management. I found this library site that has helped me to understand ‘asset management’ as a generic topic rather than just a Maximo view. Now Maximo does incorporate much of this information, this web site gives a more complete explanation of ‘why’ Maximo works the way it does.
http://www.iaitam.org/Best_Practice_Library.htm
Submitted Anonymously:
This tip is for anyone having trouble populating fields in reports in Maximo 4.
When running any report in Maximo 4, be sure to hit the enter key to bring up a record on screen in order to populate the field. This will prevent the error message "No key value."
Submitted Anonymously:
This tip is a Maximo/Actuate conversion which is extremely helpful if you are upgrading from 6.1 to version 6.2 and above with reports.
If you migrate to Maximo 6.2 and above the reports will REQUIRE new libraries all of them are called Maximoxxxxxxxxxxx.rol. If you plan on converting the reports from Maximo 6.1 to 6.2 and above you will need to rebuild and recompile the reports. The encryption algorithm is different and WILL cause your 6.1 report to fail in a 6.2 environment.
Submitted Anonymously:
The February tip, submitted anonymously, is a tip for searching for all work orders that belong to you. This tip is for Maximo 6 and Maximo 7.
(This only works if youre the supervisor of the work order, If you are the owner of the work orders you can change supervisor to owner in the query)
Enter this query into the ‘Where Clause’ on the List Tab of Work Order Tracking screen 
WHERE ((WOCLASS = 'WORKORDER' or WOCLASS = 'ACTIVITY') AND HISTORYFLAG = 0 AND ISTASK = 0 AND SITEID = 'YourUserSite') and supervisor = 'YourUserID'
Note you will have to change YourUserID and YourUserSite to match your company.
This tip submitted by George Brownwell of Lantic Inc:
To make a queries global, inserting :user (no quotes) after the equals sign enables the query to be valid for the user logged in. One query may be made public for all users of the system. (See query code below). This tip is for Maximo 6 and Maximo 7.
(This only works if youre the supervisor of the work order, If you are the owner of the work orders you can change supervisor to owner in the query)
WHERE ((WOCLASS = 'WORKORDER' or WOCLASS = 'ACTIVITY') AND HISTORYFLAG = 0 AND ISTASK = 0 AND SITEID = 'YourUserSite') and supervisor = :user
This tip is for Application Designer in Maximo 6 and 7:
In Application Designer for Maximo 6 and 7, replace a Textbox with a Multiline Textbox for a field that you need a bit wider to see the whole value on the screen (sound familiar)? Since the length (number lines) and width (characters) of the Multiline Textbox is configurable, you can set it to a single line but have complete control over the width. Not a good practice to implement globally, but it is a great work around for those occasional fields where it is very important for people to see the entire field contents.