IBM Maximo consultant, geek, agile evangelist
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 […]
Many customers I work with use a procedure like this one to clone Maximo environments between production, test and development environments. When you use such techniques, you may quickly screw up some settings used during installation of Maximo fixpacks and upgrades.Here are some important things to check before installing any release, fixpack or add-on. Maximo […]
My job brings me across Europe to meet many different customers and work with a vast variety of Maximo environments. One of the most important tasks is to be able to quickly assess a Maximo environment that I have never seen before. How much data? One of the tools I use is a set of […]
Before Maximo 6 it was a common practice to implement customizations using database triggers. Although Conditional Expressions, SigOptions, Java coding and scripting are now available in Maximo 7, I still see many Maximo environments with a lot of database triggers.In a recent project I have found a Maximo system with more than 30 triggers and […]