3 Replies Latest reply on Nov 13, 2016 7:28 PM by John Layne

orphan files not used in assemblies

John Layne Nov 11, 2016 3:34 AM

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

Re: orphan files not used in assemblies

Prasad Bhonsule Nov 11, 2016 7:19 AM (in response to John Layne)
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

List Files With No References (S-060847).sql.zip 539 bytes
Like Show 1 Likes(1)

Actions
- Re: orphan files not used in assemblies
  
  Charley Saint Nov 11, 2016 12:30 PM (in response to 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.
  
  Report Examples 1.crp.zip 827 bytes
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: orphan files not used in assemblies
    
    John Layne Nov 13, 2016 7:28 PM (in response to Charley Saint)
    
    Thanks Charley (and Prasad), much appreciated that just what I was looking for. That'l save me a lot of time.
    
    John.
    
    Like Show 0 Likes(0)
    
    Actions

Go to original post