Report or query to find "Copied from" representations

[HJ1]

Version: Windchill 12.1

Use Case: Need to delete old representations. DeleteRepUtil could be used, but how to find the input OIDs for it.

Description:

Does anyone have a report or query to list "Copied from" representations on EPMDocuments and preferably their OIDs to be used as input for the DeleteRepUtil on the server?

I'm looking to delete also old "Derived from" to restore disk space and there's some handy report provided by PTC, but I noticed that didn't pick the "Copied from" (which would be more important to get rid of as it's incorrect data on the object..).

We use WTParts, just mentioning as I learned that may affect how the reports work.

[Marco_Tosin]

Take a look at this article

QML report to fetch all EPM Documents having copied from representation in Windchill PDMLink

[HJ1]

Thanks, that particular was discussed thoroughly with PTC techies and the outcome was it does not work because of the WTParts being in play.

[Marco_Tosin]

Have you already looked also at this article?

How are Representations stored in the database and how are EPMDocuments linked to them in Windchill PDMLink

[vnamboodheri]

Hello HJ1,

It looks like you have some responses from our community champion. If it helped you solve your question please mark the reply as the Accepted Solution. 
Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.