User Last Login datetime

Betsy_Kowan

Hi,We are running LiveLink v.9.7.0. I want to write a Livereport to show me the last login date and time for all users in a particular group. Can somebody please help me? Any help will be greatly appreciated. Thanks.RegardsPeter

Joe_Vicioni

Message from Joe Vocioni <Joe.Vocioni@gov.ab.ca> via eLink

eLink

Hey Peter,

 

Here’s a script we use for aspecific group; it’s written for oracle and checks the last 30 days ofactivity.

 

select     count(1) "Activity",

            u.firstname || ' ' ||u.lastname "Name",

           Max(a.auditdate) "LastAccess"

from        (select ChildID fromKUAFChildren

         start with ID = <GROUP OBJECT ID>

         connect by prior ChildID = ID) g,

        kuaf u,

         dauditnew a

where g.ChildID = u.Id

and u.type = 0

and u.deleted = 0

and u.id <> 1000

and u.id = a.userid

and a.auditstr in ('Login')

AND a.AUDITDATE>SYSDATE-30

group by u.firstname || ' ' || u.lastname

order by count(1) desc

 

 

From: eLinkDiscussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, June 30, 2008 3:01PM
To: eLink Recipient
Subject: User Last Login datetime

 

User Last Login datetime

Posted by eu0014893admin (Chan, Peter) on 06/30/2008 04:58 PM

 

Hi, We are running LiveLink v.9.7.0. I want to write a Livereport to show me the last login date and time for all users in a particular group. Can somebody please help me? Any help will be greatly appreciated. Thanks. Regards Peter

 

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.