Usage statistics on a specific livelink object

Robert_Power_(crhadmin_-_(deleted))

My requirement is to produce a report detailing usage statistics of a specific livelink item i.e. #logins, actions taken, user etc. I've got some code that's relevant to Oracle:select daudit.*, k.name from daudit, kuaf k where dataid in (select dataid from dtree connect by prior dataid = parentid start with dataid = 2000) and (EVENT='VIEW' or EVENT='FETCH') and (auditdate >= to_date('07 December 2003','DD Month YYYY') and auditdate <= to_date('07 January 2004','DD Month YYYY')) and k.id=daudit.useridI'm told "connect by prior" is Oracle specific.. we're using SQL backend.. can anyone help with changing above code to SQL?Rgds,Brian

Bhupinder_Singh

Message from Bhupinder Singh via eLinkFor using an MS-SQL equivalent of "CONNECT BY PRIOR", see the posting at:https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3244151&objAction=view&show=2- Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed.Senior Product Specialist, Customer SupportOpen Text Corporation, Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, January 08, 2004 8:07 AMTo: eLink RecipientSubject: Usage statistics on a specific livelink objectUsage statistics on a specific livelink objectPosted by Lilly, Brian on 01/08/2004 07:54 AMMy requirement is to produce a report detailing usage statistics of aspecific livelink item i.e. #logins, actions taken, user etc.I've got some code that's relevant to Oracle:select daudit.*, k.name from daudit, kuaf k where dataid in (select dataidfrom dtree connect by prior dataid = parentid start with dataid = 2000) and(EVENT='VIEW' or EVENT='FETCH') and (auditdate >= to_date('07 December2003','DD Month YYYY') and auditdate <= to_date('07 January 2004','DD Month YYYY')) andk.id=daudit.useridI'm told "connect by prior" is Oracle specific.. we're using SQL backend..can anyone help with changing above code to SQL?Rgds,Brian[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