cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Participant

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 3

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

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.

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

Hi Binesh,

Thanks for reply.

Is it a DB Query or Report Builder ?

Appreciate your help.

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

This is the relationship for a SQL query

Announcements
LiveWorx Call For Papers Happening Now!