New user / admin in PDM Pro
I’ve transferred a few legacy projects across to our new vault. But have managed to add referenced files by accident. Now I have quite a number of orphan files that aren’t used in assemblies.
Is there a report that I can run to find files that aren’t used in assemblies?
I can go through the “Where used tab for all files but that would take days.
Regards
John
HI John, take a look at the attached SQL query. It's not in PDM Report (.crp) format unfortunately, but there are instructions in the PDM Administration guide on how to turn a SQL query into a PDM Report
Hope this helps
Prasad Bhonsule
Made a few changes to limit to only parts, assemblies or drawings and split it into 2 reports so you can see only files that have ever been checked in or also see files that have never been checked in which never have any references but doesn't mean they are orphaned.
Thanks Charley (and Prasad), much appreciated that just what I was looking for. That'l save me a lot of time.
John.
Made a few changes to limit to only parts, assemblies or drawings and split it into 2 reports so you can see only files that have ever been checked in or also see files that have never been checked in which never have any references but doesn't mean they are orphaned.