Skip to main content
R
RichSerafin1-Visitor
1-Visitor
May 5, 2011
Question

Intralink Searches

  • May 5, 2011
  • 2 replies
  • 951 views

Hi Folks,


We are looking for an easy way to find items that have no usage in our Intralink 3.4 database. We're also looking for a method to identify parts & assemblies that have the same name, i.e., xxxxxx.prt & xxxxxx.asm. I haven't found a way to create a reliable search for either task and doing it manually is time consuming. Any help would be greatly appreciated!



Rich

2 replies

R
RandyJones20-Turquoise
20-Turquoise
May 5, 2011
On 05/05/11 09:40, Rich Serafin wrote:
> Hi Folks,
>
> We are looking for an easy way to find items that have no usage in our Intralink
> 3.4 database. We're also looking for a method to identify parts & assemblies
> that have the same name, i.e., xxxxxx.prt & xxxxxx.asm.

This will show you objects with the same basename:

alter session set current_schema=pdm;
column basename format a100;
set lines 100;
set pages 500;

select substr(piname, 1, instr(piname,'.',1) - 1) basename
from pdm_productitem
where piname like '%.asm' or piname like '%.prt'
group by substr(piname, 1, instr(piname,'.',1) - 1)
having count(piname) > 1
order by basename;

> I haven't found a way to
> create a reliable search for either task and doing it manually is time
> consuming. Any help would be greatly appreciated!
>
> Rich
>
>


--
------------------------------------------------------------------------
Randy Jones
Systems Administrator
Great Plains Mfg., Inc.
1525 E North St
PO Box 5060
Salina, KS USA 67401
email: -
Phone: 785-823-3276
Fax: 785-667-2695
------------------------------------------------------------------------
A
amedina1-Visitor
1-Visitor
May 5, 2011
I think you need to do an SQL search on your database directly. Intralink
3.4 does not have that kind of search in its GUI. You can for example do an
sql for all part numbers

234323
234234
2342334
23423
234234

and in an outside program filter out items with repeated names like:
234234

then using that list, you can make a Jlink application that properly (using
the intralink GUI) modifies each part or deletes parts you don't want...
maybe if its repeated and also is not used = delete the part for example.

I think it would not be too hard to do that.
the oracle table PDM_FOLDER contains the folder locations for parts
the table PDM_FILE_TMP seems to contain vault name+partnumber
I was digging a for only a few minutes to get this.

regards,

Alfonso

Terms & ConditionsCookie settingsAccessibility statement