Skip to main content
atiwari-21-Visitor
1-Visitor
Feb 24, 2017 7:57 PM UTC
Question

We want to a report in Intralink 10.2 ( all file names, size and version details).

We want to a report in Intralink ( all file names, size and version). We tried to use QML and SQL Query to get this info but no luck. How can we get this report in Intralink ?

Thank you.

3 replies

BineshKumar12-Explorer
2-Explorer
Feb 26, 2017 5:34 PM UTC

Are you looking to get both EPM and WTDocuments?

For EPMDocument / CAD Documents

- Name, Number - EPMDocumentMaster table

- VERSIONIDA2VERSIONINFO, ITERATIONIDA2ITERATIONINFO from EPMDocument table.

- File size from applicationdata table

Link

- EPMDocument table's ida3masterreference = EPMDocumentmaster's ida2a2

- holdertocontent table's ida3a5 = EPMDocument table's ida2a2

- holdertocontent table's ida3b5 = applicationdata's ida2a2

For WTDocuments/Non Cad documents

- Replace EPMDocument with WTDocument, EPMDocumentMaster with WTDocumentMaster

- For non cad documents, you can get the filename from applicationData table.

Translate
atiwari-21-VisitorAuthor
1-Visitor
Mar 8, 2017 8:17 PM UTC

Hi Binesh,

Thanks for reply.

Is it a DB Query or Report Builder ?

Appreciate your help.

Translate
BineshKumar12-Explorer
2-Explorer
Mar 8, 2017 10:15 PM UTC

This is the relationship for a SQL query

Translate
Terms & ConditionsAccessibility statement