Who has logged in from a spesific group?

Hi,I'm trying to write a report that let me select a group and then shows me who has logged in from that group. This is what I tried:select ID "id" , Name "name" ,AuditDate "Audit" FROM KUAF, DAudit where Event = 'LOGIN' and DAudit.UserID = KUAF.ID order by KUAF.nameI am using Livelink 9.0.0.1 with ms-sql.Any ideas would be appreciated.Matthys

Find more posts tagged with

Comments

Liz_Connors_(sunvalleyfoodadmin_-_(deleted))

The DAUDIT table only stores rows that are written to it, so if you Login a row is written, if you use the Logout option from the menu then a row is written. If you logged in two weeks ago, for a few hours and then went off to another site before closing your browser down you are still Logged In as there is no corresponding Log Out event, even though if you try and access Livelink you get another Logion prompt.

eLink User

Message from Marie Lindsay via eLinkSeems like you might want a list of groups first:select id, name "group name" from kuaf where type = 1Then a sub-report that shows users from that group who have logged in:select kuaf.name "Who", daudit.auditdate "When Logged In" from daudit, kuaf,kuafchildren where kuafchildren.id = %1 and kuafchildren.childid =daudit.userid and kuaf.id = daudit.userid> -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Wednesday, August 15, 2001 2:43 AM> To: eLink Recipient> Subject: Who has logged in from a spesific group?>>> Who has logged in from a spesific group?> Posted by iCISAdmin on 08/15/2001 03:37 AM>> Hi,>> I'm trying to write a report that let me select a group and then> shows me who has logged in from that group. This is what I tried:> select ID "id" , Name "name" ,AuditDate "Audit"> FROM KUAF, DAudit> where Event = 'LOGIN' and DAudit.UserID = KUAF.ID order by KUAF.name> I am using Livelink 9.0.0.1 with ms-sql.> Any ideas would be appreciated.> Matthys>>>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from Marie Lindsay via eLinkI believe this is correct except for one thing: There is no "logout" auditevent... This is probably because there are so few people who actuallychoose the Logout command, it would be an invalid reflection of activity.(Most people just close their web browsers.)> -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Wednesday, August 15, 2001 8:35 AM> To: eLink Recipient> Subject: 'Logged In' is not as clear cut as you would hope>>> 'Logged In' is not as clear cut as you would hope> Posted by SunValleyFoodAdmin on 08/15/2001 09:32 AM>> The DAUDIT table only stores rows that are written to it, so if> you Login a row is written, if you use the Logout option from the> menu then a row is written. If you logged in two weeks ago, for a> few hours and then went off to another site before closing your> browser down you are still Logged In as there is no corresponding> Log Out event, even though if you try and access Livelink you get> another Logion prompt.>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Who has logged in from a spesific group?> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2571828&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe