Large documents in Livelink

What would be the sql to find the 10 largest documents in Livelink? I have tried using LiveReports but it keeps timing out.Thanks in advance.

Find more posts tagged with

Comments

eLink User

Message from Mohsin Jessa via eLinkIs your d/b Oracle ? If so, can you please send me the SQL (from thelivereport) that you are running and timing out. If the d/b is not oraclethen you can wait for someone else to respond or open a ticket with thecustomer support. _____Mohsin M. JessaOracle Technical Specialist (Escalation Group)Open Text CorporationPh: 519-888-7111 x 2416Fax: 519- 888-6737Email: mjessa@opentext.com _____Join us in Orlando for LiveLinkUp 2003!Open Text ConferenceOrlando, Florida, USANovember 3-6, 2003Find out how we're helping sixteen million great mindswork together to improve efficiencies and save money.www.opentext.com/livelinkup/2003-Orlando-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, August 07, 2003 11:18 AMTo: eLink RecipientSubject: Large documents in LivelinkLarge documents in LivelinkPosted by Brown, Allen on 08/07/2003 10:59 AMWhat would be the sql to find the 10 largest documents in Livelink? I havetried using LiveReports but it keeps timing out.Thanks in advance.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Sandra_Becker

Message from Becker Stefan <<A HREF="mailto:stefan.becker@siemens.com">stefan.becker@siemens.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">Nachricht

This sql Statement works with our oracle database:

select d.dataid, d.name, round(v.datasize/1024/1024, 2) || ' MB' "Sum in MB", v.version, v.vercdate creationdate from dtree d, dversdata v where d.dataid = v.docid order by v.datasize desc

-----Ursprüngliche Nachricht-----
Von: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Gesendet: Donnerstag, 7. August 2003 17:18
An: eLink Recipient
Betreff: Large documents in Livelink

Large documents in Livelink Posted by NorCDNAdmin (Brown, Allen) on 08/07/2003 10:59 AM

What would be the sql to find the 10 largest documents in Livelink? I have tried using LiveReports but it keeps timing out.

Thanks in advance.