I am looking to clean up our vault and clean up any orphaned parts that have no parent assembly (not used in) or have a sub assembly of it's own.
We would like to assign a custom status to them for review manually to put them in to an EOL status or put them back into an active status.
Is there a quick way to do this or an SQL query that would handle this?
Hi Cory, take a look at the attached SQL query, also take a look at Solution S-060847 in the SolidWorks Knowledge Base
Retrieving data ...