cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Queries

jeffkennedy
1-Newbie

SQL Queries

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.

Thanks,


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.
0 REPLIES 0
Announcements