Clarity

Hello,

We are doing cleanup activity. We need to find if a few db objects views/proecedure/functions etc are in use anywhere. Is there way to search for reference in processes/queries/lookups/business objects?

Please share your ideas.

Thank you,

Rajani.

Hi Rajani

Just to make sure as it wasn't specifically mentioned: OOTB CA PPM database objects, even if not in apparent use, should not be removed. Please ensure you do not remove anything that is OOTB from the database as this can cause issues and make your system unsupported.

Now if you would like to clean up customizations, there is no way to easily determine which ones are in use in Clarity PPM. However, what you can do is run the checkinstall utility from a higher CA PPM version and collect the txt files containing potential customizations. It can also contain OOTB objects, so carefully go through the list, and determine what is a customization on your environment.

Then see the customizations you are still using or not and you may match them to your WEBI SQL, custom scripts and lookups. The ones you don't, may be dropped. We recommend the customers to keep a document with all database customizations and what they do, and which objects they include.

If the above doesn't help you, and you don't know what's in use, then you could just drop the customizations you currently have on your Test environment and have a group of users test the functionalities they use and report if they see something missing/not working.

I hope this helps -NIka