Find EPMDocument to wtPart associations that have never been built

I noodled on this for a LONG time a while back.  Can't seem to find the report that I came up with.

Will try to dig up and post.

Note: One way that I found to figure these out on a test Windchill system with no other users or activity is this (using Oracle):

- In Oracle, update statistics (have to do this)

- In Oracle, query the number of rows in all tables and export to spreadsheet

- Make a single change in Windchill (e.g. Build a WTPart / EPMDocument with an existing but not yet built assocation)

- In Oracle, again update statistics

- In Oracle, again, query the number of rows in all tables and export to spreadsheet

- In a spreadsheet, find any tables which have new rows

- Focus on these table(s) for Reports.

exec dbms_stats.gather_schema_stats('<username>');

select table_name,num_rows from user_tables where num_rows > 0 order by table_name

Can this article help you?

https://www.ptc.com/en/support/article/CS332588

Hi @BrianToussaint 

information is stored in a EPMBuildHistory

if the row does not exist the Build has never been done 

SQL could look like >

select EPMMaster.documentNumber,build.* from wcuser.EPMBuildRule build 
inner join wcuser.EPMDocument EMDocument on build.branchIdA3A5=EMDocument.branchIditerationInfo 
inner join wcuser.EPMDocumentMaster EPMMaster on EPMMaster.idA2A2=EMDocument.idA3masterReference
where EPMMaster.documentNumber not in (select EPMMaster2.documentNumber from wcuser.EPMBuildHistory buildH 
inner join wcuser.EPMDocument EMDocument2 on buildH.idA3A5=EMDocument2.idA2A2 
inner join wcuser.EPMDocumentMaster EPMMaster2 on EPMMaster2.idA2A2=EMDocument2.idA3masterReference)

PetrH