intermediate

Sync data between Maximo and Excel

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 […]

List Maximo customizations

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 performances and network latency

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 […]

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 […]

Checkpoints for fixpack and addon installation

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 […]

Scroll to top