Determining changes to documents in Livelink 9.5

Bobby_White_(veneti01admin_-_(deleted))

We have a requirement to periodically determine what changes have been made to documents stored in Livelink. These changes include new/updated/deleted documents. I see this exact type of information when I query the audit log, however, this is obviously an interactive feature, which is not what we need. We're looking for a way to query this same audit log from an application, either using an API or reading from the DB table where the audit events exist. Livelink support has already mentioned that the Livelink API does not provide a way to query the audit log, so the API approach is not an option. Has anyone ever had this same requirement, and if so, what was the solution. If not, does anyone have any ideas/recommendations? We're basically looking for another possible to query the audit log, maybe by going directly to the DB?Thanks!!!!

eLink User

Message from Nair, Krishnankutty N. via eLinkWe do this by invoking sqlplus on our DB(oracle) machine and then crontabbing( a term in unix for a scheduled task) the results.The query getsexecuted by sql plus,unix executes it as a KSH and we use mailx tomailout the results.Using this we mail out audit report,size usagereport etc on our livelink schema as the customers ask us.If you were windows oriented you could possibly create a vbscript anduse sqlplus on windows(there is a command line available) and schedulethe VBS on a periodic basis.If you were using SQLserver as a backend see if there are inbuilt toolsfor unattended reportingIf you wanted livelink to do the job you could create an "agent", seecustomagent and have it execute your CAPI query.You could call the mailutility in livelink to do this also.this would be livelink programmingeffort using the builderHope this helps you in your endeavour.Thanks MuchKrishnankutty N NairWork 918-661-5824 Fax:918-661-9206Learn more about EDMS powered by Livelink athttp://edms.conoco.net/edms.htm-----Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com] Sent: Wednesday, October 12, 2005 9:41 AMTo: eLink RecipientSubject: Determining changes to documents in Livelink 9.5Determining changes to documents in Livelink 9.5Posted by White, Bobby on 10/12/2005 10:38 AMWe have a requirement to periodically determine what changes have beenmade to documents stored in Livelink. These changes includenew/updated/deleted documents. I see this exact type of information whenI query the audit log, however, this is obviously an interactivefeature, which is not what we need. We're looking for a way to querythis same audit log from an application, either using an API or readingfrom the DB table where the audit events exist. Livelink support hasalready mentioned that the Livelink API does not provide a way to querythe audit log, so the API approach is not an option. Has anyone ever had this same requirement, and if so, what was thesolution. If not, does anyone have any ideas/recommendations? We're basically looking for another possible to query the audit log,maybe by going directly to the DB?Thanks!!!![To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Development Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/786303Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.development@elinkkc.opentext.com.