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 securityrestrict
ORDER BY objectname, attributename;
Custom objects and attributes
SELECT * FROM maxobject
WHERE userdefined=1
ORDER by objectname;
SELECT * FROM maxattribute
WHERE userdefined=1
ORDER by objectname, attributename;
Custom code
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
Good post!!!
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.
Regards,
Shahid Saeed Khan,
+92.334.3256540
What if we’ve to determine any DB Procedure or Trigger made out of the box?