Skip to main content
A
atiwari-21-Visitor
1-Visitor
February 24, 2017
Question

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

  • February 24, 2017
  • 3 replies
  • 1747 views

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

B
BineshKumar12-Explorer
2-Explorer
February 26, 2017

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.

A
atiwari-21-VisitorAuthor
1-Visitor
March 8, 2017

Hi Binesh,

Thanks for reply.

Is it a DB Query or Report Builder ?

Appreciate your help.

B
BineshKumar12-Explorer
2-Explorer
March 8, 2017

This is the relationship for a SQL query

Terms & ConditionsAccessibility statement