Skip to main content
J
jschutte10-Marble
10-Marble
June 22, 2022
Solved

Number count of prt, asm, & drw files in Windchill 11.2.1.0

  • June 22, 2022
  • 2 replies
  • 3853 views

Is there a fast, easy way to get the exact number of only the latest revisions of every prt, asm, & drw files in Windchill 11.2.1.0?   This is actually Intralink 11.2.1.0 which we are planning to upgrade soon.

 

Thanks,

Joe S.  

Best answer by RandyJones

Since you only want know the number of latest Revisions you can simply query the epmdocumentmaster table:

select count(*) Num_Prts from epmdocumentmaster where cadname like '%.prt';
select count(*) Num_Asms from epmdocumentmaster where cadname like '%.asm';
select count(*) Num_Drws from epmdocumentmaster where cadname like '%.drw';

2 replies

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
June 22, 2022

Easiest is write a SQL query and look at the EMPDOCUMENT table. There is a column which indicates if it is the latest iteration of a particular version. Do you have access to run queries against DB?

    J
    jschutte10-MarbleAuthor
    10-Marble
    June 22, 2022

    I have full access to the server.  However, I have no clue how to write or run a SQL query.    I actually suspected this would be the recommendation.  I was hoping that there was a tool somewhere in Windchill I could use.  

     

    Any suggestions on how to write & run this query?

     

    M
    22-Sapphire I
    MikeLockwood22-Sapphire I
    22-Sapphire I
    June 22, 2022

    If you only have 5 CAD seats, you may have an amount of data that can be determined using a simple Windchill search.

    Search filter for latest Iteration, and the preference can be set for latest Version (Revision) only.

     

    It will stop at 2000 by default, but you can hit Next, Next until the search completes, then simply see how many.

    Can filter the search each time, one each for for Document Category = Part, Assembly, Drawing.

      J
      jschutte10-MarbleAuthor
      10-Marble
      June 22, 2022

      Thanks everyone who replied.   Problem solved.   This reminded me of our old user group!

       

      -joe

       

      Terms & ConditionsCookie settingsAccessibility statement