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 […]
Automatically set Everyplace start center for mobile users
Maximo Everyplace is the easiest solution to go mobile with Maximo however there is one little thing that always annoys me (and mobile users). After having created mobile versions of the Maximo apps, the administrator has to define a mobile start center with a Favorite Applications portlet to access them. Unfortunately, there is no way […]
How to improve DocLinks performances in Maximo/TPAE applications
During a performance assessment of a production customer environment I have set the mxe.db.logSQLTimeLimit system property to 2000 to log all long-running SQL statements (see this TechNote for details). Looking at the system logs I have noticed many entries like this. select * from doclinks where (ownertable=’WORKORDER’ and ownerid=1065680) or (ownertable=’WORKORDER’ and ownerid in (select […]
MBO Performance Tip N.6 – Free resources as soon as possible
This entry is part of the Java MBO performance optimization golden rules series. It is important to know the difference between close(), cleanup(), and clear() methods and use them to free up resources as soon as possible. close(): Close the cursor, release the database resources (result set), SQL statement, and connection key. Does not release […]
Maximo URLs
TPAE-based products like MAM, TAMIT, TSRM, CCMDB or SCCD provide a common way to open an application and perform some basic action like displaying a specific entry or performing a simple query. This can be very useful to integrate Maximo with other applications implementing navigation integration or launch in context. The base URL has this […]
Query users and groups security
Did you have ever spent precious time searching in the Group Security application what group grants a specific permission to a certain user?Do you want to list all the sigoption granted to a specific user?Do you want to list all the groups to which a specific user belongs together with all the granted sigoptions?Do you […]
Search for NULL values in Maximo applications
Today I want to share with you a little tip that allows to search for empty (NULL) values in every Maximo/TPAE application.You can search for null and not null values by entering the following values into a search field on the Find tab: To search for a null value enter: ~null~ To search for not […]