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

Forum|Forum|3 years ago
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.

CAD Data Mgmt

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';

avillanueva

23-Emerald I

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

jschutte

Author

10-Marble

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?