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

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

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'