SQL statements for matching EPM docs to vault name

[bmills]

Designation: Non-SSA/Finmeccanica

Good Morning everyone,

Could someone provide me with a sample SQL query that I can run that
will give me vault information for a particular EPM document. This would
include replication data as I am replicating to a remote site.



Intralink 9.1 M050



Bob Mills

Engineering Software Administrator



DRS Training and Control Systems, LLC

645 Anchors Street

Fort Walton Beach, Florida 32548

850-302-3241

rmills@drs-ds.com <">mailto:rmills@drs-ds.com> www.drs-ds.com
<">http://www.drs.com>



3.1.1001

[MikeLockwood]

Can use a Query Builder Report for this. See sample attached.

[jkent]

This is what I use to find vault files on SQL Server. Doesn't give
replication info but you could modify to suit your needs.



SELECT

EPMDocumentMaster.CADName "FileName"

,FvVault.name "VaultName"

,FvFolder.name "VaultFolder"

,sys.fn_varbintohexsubstring(0,CAST(FvItem.uniqueSequenceNumber
AS VARBINARY(7)),1,0) "FileInFolder"

,FvItem.idA2A2 "ItemID"

FROM

HolderToContent

,ApplicationData

,EPMDocumentMaster

,EPMDocument

,FvFolder

,FvVault

,FvItem

WHERE

EPMDocument.idA3masterReference = EPMDocumentMaster.idA2A2

AND HolderToContent.idA3A5 = EPMDocument.idA2A2

AND HolderToContent.idA3B5 = ApplicationData.idA2A2

AND ApplicationData.idA3A5 = FvItem.idA2A2

AND FvItem.streamId IN (

SELECT

FvItem.streamId

FROM

FvItem

,FvFolder

,FvMount

WHERE

FvItem.idA3A4 = FvFolder.idA2A2

AND FvMount.idA3A5 = FvFolder.idA2A2

)

AND FvFolder.idA3A5 = FvVault.idA2A2

AND FvFolder.idA2A2 = FvItem.idA3A4

AND EPMDocumentMaster.CADName = 'model_program_new.prt';



From: Lockwood,Mike,IRVINE,R&D [