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

[atiwari-2]

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.

[BineshKumar1]

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.

[atiwari-2]

Hi Binesh,

Thanks for reply.

Is it a DB Query or Report Builder ?

Appreciate your help.

[BineshKumar1]

This is the relationship for a SQL query