Question
Identify Active/Inactive Containers, Creation Date, Modification Date and Container Usage Statistic
I am using Windchill PDMLink Release 11.0 and Datecode with CPS M030-CPS22
We are assessing a migration from Windchill 11.0 to 12.0 and need to assess the utilization of Products, Libraries, Projects and other containers.
We need to identify container creation/modification dates, object counts by container (WTPart, WTDocument, EPMDocument, Change objects, etc.), latest object creation/modification activity, and available indicators to identify actively used vs. potentially inactive containers.
Please advise the PTC-supported approach using Query Builder/Report Builder, Report Manager, OOTB reports, APIs/REST Services or other supported methods. If not feasible, please confirm whether a read-only Oracle DB query is supported and provide the relevant classes/tables and relationships.
Also, please confirm which timestamp and version/iteration should be considered for latest activity.

