cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to determine the number of unique part numbers site wide in Windchill?

SOLVED

Re: How to determine the number of unique part numbers site wide in Windchill?

Your query builder report is returning unique document masters, not every version of each document.

Fundamentally which are you looking for, total number of all object versions in the system, or just the total number of unique objects (filenames)?

Re: How to determine the number of unique part numbers site wide in Windchill?

Hello Tom,

Thanks for your input on this question.

I'm looking for the total number of each of drawing, part, and assembly.  But I want to do a sanity check on the results.  In my case the number of drawings seems low based on the number of parts and assemblies.  Given many parts will be library parts or import data from sub-contractors and that may explain it but right now I can't prove it. 

But I guess with this type of investigation one has to cut it off somewhere and call the answer good enough for this purpose, maybe I've reached that point.

- Jim

Re: How to determine the number of unique part numbers site wide in Windchill?

I'm looking for the total number of each of drawing, part, and assembly.

This still seems nebulous.  Assume the following objects exist in the system.

abc.prt   -.0

abc.prt   -.1

abc.prt   -.2

abc.prt  A.0

abc.prt  A.1

Do you want the result to return '1', or '5'?

Re: How to determine the number of unique part numbers site wide in Windchill?

If you want '5', switch your query builder table to EPMDocument instead of EPMDocumentMaster.  (If you do this, change your criteria to use File Name instead of CAD Name.)

Re: How to determine the number of unique part numbers site wide in Windchill?

Here's a query builder report that gives the same output as my original SQL statement above (all unique versions).  Report is attached.

QB_Count_Objects.png

Re: How to determine the number of unique part numbers site wide in Windchill?

And here is a query builder report that only returns unique objects (unique number).  It too agrees with my second SQL post above.

QB_Count_Objects2.png

Re: How to determine the number of unique part numbers site wide in Windchill?

The result I expect is 1 in your example list above.

Re: How to determine the number of unique part numbers site wide in Windchill?

I think I'll start a new thread, as my current thinking is building on this initial question which we've now collectively answered.  Thanks again Tom Uminn‌ and Mike Lockwood‌.

Re: How to determine the number of unique part numbers site wide in Windchill?

In case if you have access to datebase you may take a look at key table (EPMDOCUMENTMASTERKEY, WTPARTMASTERKEY etc). those will give unique parts and epmdocuments.

Re: How to determine the number of unique part numbers site wide in Windchill?

Thanks Tom,

I added a link at your QML files to the Resource for reporting

Document is open, so if you want you could do the same in the future.

Marco