Need SQL query for Creo Elements/Pro unique objects that includes revisions and iterations in WC PDMLink 10.1 DB

[ArturPonurski]

Hi All,

I thought I had it somewhere when we migrated from Intralink to PDMLInk but no luck finding it so I might have some luck on this forum.

Need sql query to find in Windchill PDMLink 10.1 database 2 counts:

1. Number of Creo Elements/Pro Unique Objects (unique file names and/or part numbers)


2. Total Creo Elements/Pro Objects (includes revisions and iterations)

Regards, Artur

[atre.shreyas]

Below two SQL queries may help you.

1.Number of Creo Elements/Pro Unique Objects (unique file names and/or part numbers)

select CADName,name,documentNumber,[authoringApplication] from [wcadmin].[wcadmin]. EPMDocumentMaster where authoringApplication ='PROE'

2. Total Creo Elements/Pro Objects (includes revisions and iterations)

select count( b.idA2A2)

from [wcadmin].[wcadmin]. EPMDocumentMaster a, [wcadmin].[wcadmin]. EPMDocument b where

a.idA2A2=b.idA3masterReference and authoringApplication ='PROE'

Hope it helps !!

Thanks

Shreyas

[ArturPonurski]

Many thanks! I used 2 below counts and I think I have what I wanted. Thx, Artur

SELECT COUNT(*) FROM EPMDocumentMaster WHERE authoringapplication='PROE';

select count( b.idA2A2)
from EPMDocumentMaster a, EPMDocument b where
a.idA2A2=b.idA3masterReference and authoringApplication ='PROE'