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.
SELECT * FROM securityrestrict
ORDER BY objectname, attributename;
Custom objects and attributes
SELECT * FROM maxobject
ORDER by objectname;
SELECT * FROM maxattribute
ORDER by objectname, attributename;
For an accurate analysis of customized Java classes you can use the IBM Maximo Customization Detection Tool. When the customization detection tool is executed, it generates a report that will list all of the services, object, and attribute classes that have been extended for Maximo or Maximo industry solutions and add-on products.
You may also try another technique to compare two different Maximo instances as described in this post.
List Maximo customizations
4 thoughts on “List Maximo customizations”
Very useful for upgrade projects.
So when industry solutions like Utilities *T&D were applied to Maximo , will those additional attributes in existing OOB tables tagged as userdefined even though those are part of industry pack ?
Yes its a nice article to get details of any DB Level customizations. But my stance is that during upgrade, the previous database is updated with respect to the changes which were introduced in the new version of Maximo, and any customizations made in the previous database remains same evn in the new version after upgrade.
Kindly let me know if I’m wrong or missing anything.
Shahid Saeed Khan,
What if we’ve to determine any DB Procedure or Trigger made out of the box?