Skip to main content
BrianToussaint19-Tanzanite
19-Tanzanite
Jul 16, 2021 6:02 PM UTC
Solved

Which table is used to store EPMDocument Uses tab?

I'm trying to find what table is used for the EPMDocument Uses tab.  I could not find anything in the reporting resource.  I am trying to get a single level BOM report of all latest EPMDocument assemblies to export and compare to another system.  Does anyone know what this table is?

avillanueva
avillanuevaAnswer
23-Emerald II
Jul 19, 2021 1:23 PM UTC

Yes, EPMMEMBERLINK is the table. Links a EPMDOCUMENT iteration to a master of another EPMDocument (EPMDOCUMENTMASTER). if you care to just get latest, you can join back to EPMDocument but remember that Creo will pull latest by default to workspace so cares not. There is also EPMASSTOREDMEMBER which contains the as stored baseline from check ins if you need that data.

View in thread

5 replies

MikeLockwood22-Sapphire I
22-Sapphire I
Jul 16, 2021 6:24 PM UTC

There are some good clues from PTC on this but in general, here's what I do to find these:

- capture all the database table row counts (for Oracle, force gather statistics, then select table_name, num_rows for all). Export to Excel

- then make changes

- then repeat gather stats, export

- compare in Excel

 

In general, rows counts increase in just a few tables

 

Translate
    BrianToussaint19-TanzaniteAuthor
    19-Tanzanite
    Jul 16, 2021 6:25 PM UTC

    Thank you.  I will figure out how to do this for SQL Server.

    Translate
    avillanueva
    avillanueva23-Emerald II
    23-Emerald II
    Jul 16, 2021 6:34 PM UTC

    I believe it is EPM MEMBER or something like that. I can check in TOAD but I believe that or some variation of that is the right table. You are referring to the table that shows what CAD model is used by another CAD model right, like an assembly and its components?

    Translate
      BrianToussaint19-TanzaniteAuthor
      19-Tanzanite
      Jul 16, 2021 6:48 PM UTC

      Yes, that is what I am looking for.  I found EPM Member Link.  I can try from here to get the links and figure out what it is giving me.

      Translate
      avillanueva
      avillanueva23-Emerald IIAnswer
      23-Emerald II
      Jul 19, 2021 1:23 PM UTC

      Yes, EPMMEMBERLINK is the table. Links a EPMDOCUMENT iteration to a master of another EPMDocument (EPMDOCUMENTMASTER). if you care to just get latest, you can join back to EPMDocument but remember that Creo will pull latest by default to workspace so cares not. There is also EPMASSTOREDMEMBER which contains the as stored baseline from check ins if you need that data.

      Translate
        Terms & ConditionsAccessibility statement