SQL code for most number of hits on LL documents and folders

Paul Langham

HelloPlease can someone advise on whether we can check to see which documents and folders have had the most number of hits in Livelink?Any pointers would be appreciated.Cheers,Simon

eLink User

Message from Nair, Krishnankutty via eLinkFor documents you can check the duaditnew or pre 9.5 the daudit table.Ifthe document actions are audited the table will contain the dataid andthen the action like 'open' 'fetch'.'create' such like.For folders there is just a create,modify,permissions stuff that I cansee.I do not think livelink audits folder as 'open' or accessed .However there is a way that is famous in the KB circles.Let the folderstream a customview(an empty html) and in the customview you place aninvisible 'gif' which is really a livelink object having dataid.So whenthe folder is opened the custom view is being called as well as thehidden "gif".This can be contorted as a folder hit.Also try your luck against the webserver logs-----Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com] Sent: Tuesday, October 17, 2006 5:10 PMTo: eLink RecipientSubject: SQL code for most number of hits on LL documents and foldersSQL code for most number of hits on LL documents and folders Posted byLangham, Paul on 10/17/2006 06:05 PMHelloPlease can someone advise on whether we can check to see which documentsand folders have had the most number of hits in Livelink?Any pointers would be appreciated.Cheers,Simon[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Development Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/786303Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.development@elinkkc.opentext.com.-----------------------------------------*Please note my E-Mail Address has changed. Please update yourcontact list*Anadarko Confidentiality Notice: This electronic transmission and any attached documents or otherwritings are intended only for the person or entity to which it isaddressed and may contain information that is privileged,confidential or otherwise protected from disclosure. If you havereceived this communication in error, please immediately notifysender by return e-mail and destroy the communication. Anydisclosure, copying, distribution or the taking of any actionconcerning the contents of this communication or any attachments byanyone other than the named recipient is strictly prohibited.