Does anybody have a query that can be run to obtain attribute usage data? I am interested to get data around attribute type, when it was last updated, when the fields associated with the attribute was last used. We are doing a database cleanup and need these indicators to understand usability and what attributes can be eliminated.
Just to confirm you are talking about the APM Database (Postgres or Oracle) And APM Team Center (ATC) attributes?
Hello Hal, sorry I tagged my question incorrectly. We are looking at CA PPM application.
Unfortunately there are multiple products with identical or almost identical names. This means that the APM group sometimes gets mis-posts especially for PPM and the other APM product. The community is fairly good on catching these early and move them over. Please keep in mind for future posts. That way you get the right answer from the correct experts fast.
Thank you so much, Hal! Hopefully my message is in the right place now.
There was a recent (PPM) discussion on this sort of thing you might like to look at ;
Attribute Rationalization Process
Hello David, I really appreciate you answering to me. I did see this discussion, but the scripts shared here didn't work for us.
Thank you, Sinzi
Ok well perhaps if you add to that other discussion some of the members on that thread who have been doing such things might be able to help out (or understand your "didn't work for us" comment*)?
(* - the queries in that other discussion are likely to be specific to a particular PPM instance, so I would expect that you would still need to do some work 'tweaking' them for your instance, just use them as a guide perhaps?)