Hi, I'm new to the list and I'm hoping that someone can help me. We are using Intralink 3.3 here and I need to "harvest" some information from Intralink to integrate into an existing database on an ongoing basis. I don't have the Intralink Toolkit, nor do I need it. I do have an ODBC connection established with our Intralink Oracle database, so i have access to all of our Intralink data.
The number of tables in the Intralink database is overwhelming, so I hope that someone can help me determine which tables I need (in addition to pdm.productitem, pdm.productitemverfile, and pdm.productitemversion) to reference in SQL queries to get the following information:
1. Who, if anybody, has the print locked
2. Product Structure (Is the dependencies table where the parent/child relationships are stored? If so, Which fields represent the parent and child items?)
Any help is greatly appreciated.
Jeff S. Kennedy
Technical Publications Specialist Technical Publications Department Club Car - Ingersoll-Rand
(706) 863-3000 ext. 3355
This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.