Maximo Tips are submitted by users like you and vary between Maximo versions 4, 5, and 6. 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 monthly, and that tip is then published on this website.
The winner will be mailed a $100 American Express Gift Card. All tips are considered month after month – there is no need to resubmit a tip. Please include which version of Maximo and which database platform you are using.
Best of luck!
Maximo Tip of the Month
The April Tip of the Month, submitted by Matt Logsdon of IBM, shows the table and field name of any Maximo data field in versions 4 and 6 of Maximo.
Maximo users can find the table and field name of any Maximo data field.
In version 4 this is done by clicking on a field and choosing "What's This."
In version 6 this is done by clicking in a field then hitting Alt F1 or by hitting ALT plus the letter "i" at the same time.
Take a minute or two to check out tips from the past 6 months that Projetech has already published, and you might save yourself hours—or days!
Submitted by Annette Riske, of University of Michigan Health Systems
This tip addresses some function key shortcuts for Maximo 4.
One thing that saves time is using F2 to insert a work order with an auto number, F3 to clear the screen and F5 to save a record. Also using Control R to refresh the screen after copying and pasting something from what ever is on the screen.
Submitted by Mark Russell, of Denso Manufacturing
This tip addresses how to turn off page locking in Maximo on an SQL Server.
Problem:
Slow transactions or apparent hanging during multi-user operations in Maximo 6 applications with a SQL Server database can result if page locking has not been turned off on the tables and indexes.
Cause:
A newly installed or upgraded Maximo 6 or higher system on SQL Server does not have page locking turned off on any tables unless the table has been modified by the Configure utility. Page locking can cause performance problems.
Answer:
Connect to the Maximo database using Query Analyzer. Set the Query output to go to a file, then execute the following statement. This command must be broken onto two lines exactly as shown.
select 'sp_indexoption ''' tablename ''',''AllowPageLocks'',''false''
go' from maxtable order by tablename
Set the Query output back to screen. Click on File - Open and read in the file you just created. Delete the header and row count lines at the top and bottom of the set of commands. Click Edit - Select All, then F5 to execute all of the sp_indexoption commands. This will set page locking off for all tables and their indexes. Once turned off, it will remain off. The Maximo Database Configuration application will maintain page locking off if it rebuilds a table or index.
Submitted by Dennis Belandres, of Denso Manufacturing
This tip addresses the issues related to email links opening the wrong work order. This tip applies to Maximo 6.
Problem:
Escalation is set up to send an email to a work requestor once the task is done by maintenance to have the work order completed. Links to open the specified work order through IE does not work. If you are currently not logged in, it will link you to a log in page and if you're already log in the link will take you to the wrong work order.
Cause:
Hyperlink in the communication template shows the wrong unique id.
http://:HOSTNAME/maximo/ui/maximo.jsp?event=loadapp&value=SIGNOFF&uniqueid=:WONUM
Where the HOSTNAME is the name or IP address of the MX Server.
Solution:
Locate the column or the unique ID from the database table related to
the application. http://:HOSTNAME/maximo/ui/maximo.jsp?event=loadapp&value=SIGNOFF&uniqueid=:workorderid
http://:HOSTNAME/maximo/ui/maximo.jsp?event=loadapp&value=SIGNOFF&uniqueid=:workorderid
Submitted by Dan Herrmann of New York Power Authority
One tip used for reporting is using the hyperlinks in Crystal to go to a specific application from the report. We use Maximo 5.2, but, I assume this would work in all versions of 5 and 6. If you have ever used the send email action, it provides separate hyperlinks to the work order if you are logged in or not. For example:
Click this link if Browser is NOT open: http://YOURSERVERHERE/maximo/jsp/common/system/login.jsp?launchapp=wotrack&actions=bookmarkkey&key=WONUM
Click this link if Maximo is open:
http://YOURSERVERHERE/maximo/jsp/app/wotrack/main.jsp?doingQuery=true&find=true&querykey=WONUM
The first link will automatically ask you to log in and once logged in you will be directed to the WONUM the second link will automatically open a new window (IE6) or tab (IE7) if you are logged into Maximo.
I have begun to use the hyperlink in all my crystal reports such that the user can click to a particular work order, equipment, condition monitor point, PM, Job Plan, etc. in Maximo to do their job. I do this in Crystal under the Hyperlink tab in the Format Text Editor (see image below), I select Website on the Internet radio button and click on the formula editor and enter the base information from what was obtained above and put it in single quotes deleting the work order number and add the field. I assume the user is logged in for my reports. If not they will be prompted to log in and then the hyperlink will work, but must be clicked again.
'http://YOURSERVERHERE/maximo/jsp/app/wotrack/main.jsp?doingQuery=true&find=true&querykey=' {WORKORDER.WONUM}
What I also found was that you can use the web address from your browser to help you build a hyperlink for any screen and any table tab in Maximo.
For example, you can direct to the planned material table on the Plans screen by using:
‘ http:// YOURSERVERHERE /maximo/jsp/app/wotrack/ plans.jsp? t abletab=materials &doingQuery=true&find=true&querykey= ’ {WORKORDER.WONUM}
Or actual material table on the actuals screen:
‘http:// YOURSERVERHERE /maximo/jsp/app/wotrack/ actuals.jsp?tabletab=acmaterials &doingQuery=true&find=true&querykey=’ {WORKORDER.WONUM}
Or the spare parts screen in Equipment:
‘http:// YOURSERVERHERE /maximo/jsp/app/equipmnt/ sparepartform.jsp &doingQuery=true&find=true&querykey=’ {EQUIPMENT.EQNUM}
Generically it would be (Note the table tab is only used if you want to be directed to a specific table tab on a screen)
‘http:// YOURSERVERHERE /maximo/jsp/app/ APPNAME/SCREENNAME.jsp?tabletab=TABLETABNAME &doingQuery=true&find=true&querykey=’ {TABLE.KEYFIELD}
Submitted by Mark Russell, of Denso Manufacturing
When entering times in MXES you can use the forward slash { / } on the numeric keypad instead of the semicolon. Using military format will cause maximo to automatically put in the AM or PM when you tab out of the field.
Example:
10/25 will become 10:25 am
22/25 will become 10:25 pm
This will allow you to enter times much faster than if you try to use the semicolon and input the am or pm.
Submitted by Robert Parks of Purdue University
In Maximo 5.2, a comma "," can be used as the SQL equivalent of "or" on any Search tab.
To retrieve two equipment records with totally different equipment numbers (100001 and 630015):
Go to the Equipment/Search tab. In the equipment number field, enter:
Both records will be retrieved. The SQL on the Advanced tab is:
WHERE ((eqnum like '0001%' or eqnum like 'c0015%'))
Here are other examples of how the comma can be used for equipment numbers:
1%,6% retrieves all records beginning with 1 or 6 WHERE ((eqnum like '1%' or eqnum like '6%'))
1%,=630015 retrieves all records beginning with 1 and record 630015 WHERE ((eqnum like '1%' or eqnum = '630015'))
The comma can be used on any alphanumeric field.
Submitted anonymously
This tip shows most common wildcards for Maximo 6.
Use a wildcard to find records that begin with, end with, or contain a letter or number.
Use an asterisk(*) or percent sign (%) to stand for any number of characters (zero, one, or multiple) in the specified position. For example, enter 100* or 100% to find records that start with 100.
Use an underscore (_) or question mark (?) to stand for one character in the specified position. For example, enter 100_ or 100? to find records that start with 100 and have a fourth position.
|..Home..|..Contact Us..|.. © 2008 Projetech Inc. All rights reserved..