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)?
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.
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.
Do you want the result to return '1', or '5'?
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.)
Here's a query builder report that gives the same output as my original SQL statement above (all unique versions). Report is attached.
And here is a query builder report that only returns unique objects (unique number). It too agrees with my second SQL post above.
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.
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.