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?

     

    R
    RandyJones20-Turquoise
    20-Turquoise
    June 22, 2022

    These are actual sql queries that you run "in the database" not from a terminal or command prompt. If you have oracle you can login to the database using sqlplus (on the database host) or download sqldeveloper.

      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