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?

     

    J
    jschutte10-MarbleAuthor
    10-Marble
    June 22, 2022

    Thank you both for your replies.   It does not look like I will be climbing this learning curve & getting the numbers by myself.

     

    As I said, I was afraid this w0uld be the solution.   We only have 5 seats of Creo & Windchill requires little to no administration so there's never been a need for me to delve deeper into Windchill.  I already have another full time job.   

     

    I need these numbers very quickly, so I will have to find someone who already knows how to write & execute this SQL query.  

     

    Thanks.  

    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