Is it possible to show the folder path of a content item in the Life
Cycle Analysis Report. Can we get this information from any database table column?
Ryan,
There is no simple way to retrieve this information. The associations between Content Items and Folders, and among Folders themselves, are Folder Relationships. These Relationships are stored in the PSX_OBJECTRELATIONSHIP table.
You could create an extension that walked up the hierarchy of relationships to the Site root, and built the path that way (in other words, find the parent Folder of the Content Item, then the parent of that Folder, and so on until the path to the Site root Folder was complete).
RLJII