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.
Labels: custom, intermediate