IBM Maximo consultant, geek, agile evangelist
This entry is part of the Maximo Java Development series. You may have noticed that there are some fields that cannot be modified once an object is saved. An example of this behavior is the ASSET.ASSETNUM field. When you create a new asset you can set it’s ID but once you have saved it it […]
Roles in Maximo are used to represent a specific person or a group of people that can be used in workflows, communication templates and escalations. If you need to find which roles are used in a specific workflow you can use an SQL query like this. SELECT wfnode.title, wfnode.description, wfa.roleid, r.descriptionFROM wfnodeJOIN wfassignment wfa ON […]
This entry is part of the Maximo Java Development series. A good logging (tracing) is always a lifesaver when you have problems in a production environment. I will never stop telling to my fellow programmers how much is important to fill code with meaningful log calls. Maximo has a good and flexible logging subsystem. This […]
This entry is part of the Maximo Java Development series. What is a coding standard and why it is important? A coding standard is a set of guidelines, rules and regulations on how to write code which will help developers quickly read and understand source code conforming to the style as well as helping to […]
This article is outdated! Checkout MxLoader tool. This is the last step toward a complete integration between Maximo and Excel. In the previous article we have learned how to use Integration Object Service and HTTP calls from Excel to populate a spreadsheet with data retrieved from a Maximo server.In this new article I will show […]
This article is outdated! Checkout MxLoader tool. After having written the two articles on importing and exporting data in Maximo, this morning I woke up with an insane idea.Is it Excel capable of parsing an XML structures and issue an HTTP calls to Maximo Integration Framework?Did you already got my idea? I switched on my […]
In this little post I will share few database queries to list the customizations made to your Maximo environment. It also applies to other TPAE based products. Security restrictions SELECT * FROM securityrestrictORDER BY objectname, attributename; Custom objects and attributes SELECT * FROM maxobjectWHERE userdefined=1ORDER by objectname;SELECT * FROM maxattributeWHERE userdefined=1ORDER by objectname, attributename; Custom […]
Maximo and other IBM service management products based on TPAE (like SmartCloud Control Desk) can be seen as sitting at the apex of a pyramid that consists of network, hardware, and software services. As you can see, network performance are the foundation of the pyramid.The simplest way of measuring network performances and speed is the […]
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 […]
This entry is part of the Conditional Expressions HowTo. If you need to make a field or an object readonly if it has an active and running workflow you are in right place!All you need is a conditional expression that can be used in conditional UI or data restriction.The following conditional expression evaluate to true […]