Session Spend Time, Logins

Alfredo__Obando_(x-pemexe_-_(deleted))

How can I create a LiveReport which shows how much time a user spend on Livelink Server. How many does a user have login ?Regards.

Simon_Beal

Message from Sean O'Callaghan via eLinkWell it's easy enough to work out how may times someone logs in, butunfortunately because a logout is no longer audited it can easily giveyou a false impression of what users are doing.Here is a simple report that can tell you weekly logging by a user.select b.Name "User", a.auditdate "Login Date" from daudit a, KUAF bwhere a.auditdate < %1 and a.auditdate > dateadd(dd,-7, %1) and a.event= 'LOGIN' and (a.userid = %2) and (a.userid = b.id)%1 = user input 1 which is a Date field entitled weekending%2 = user input 2 which is a user filed entitled Select UserHope this helps you as a starting block, it can easily be modified toselect documents added, deleted etc.Sean-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 29 September 2004 00:05To: eLink RecipientSubject: [Maybe Spam] Session Spend Time, LoginsSession Spend Time, LoginsPosted by Obando, Alfredo on 09/28/2004 07:02 PMHow can I create a LiveReport which shows how much time a user spend onLivelink Server. How many does a user have login ?Regards.[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********************************************************************************This e-mail is confidential to the ordinary user of the e-mail addressand may also be privileged. If you have received it in error, pleasenotify us immediately by reply e-mail and then delete this message fromyour system. Please do not copy it or use it for any purposes, or disclose its contents to any person. Please contact our IT Departmenton +44 (0) 020 7592 0600 or e-mail at it@angeltrains.com if you needassistance. Angel Trains Limited - Portland House Stag Place VictoriaLondon SW1E 5BH Tel: 020 75920500 Fax: 020 75920519 Registered in England No 2912655www.angeltrains.com**********************************************************************************