Who are the users logged in right now?

How can a livereport be made to know who are the users logged in right now.

Find more posts tagged with

Comments

Message from via eLinkI would suggest a live report against Daudit of users who have registeredactivity in the last 20 minutes. There is no real Log out so you cannotknow for sure but defining a session to 20 minute should be reasonableaccurate.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: January 21, 2005 11:35 AMTo: eLink RecipientSubject: Who are the users logged in right now?Who are the users logged in right now?Posted by Wilson, Peter on 01/21/2005 11:27 AMHow can a livereport be made to know who are the users logged in right now.[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

John_Shoun

I have heard this asked before and as the other poster noted, the only way to way to guess at this is by making assumptions from the DAUDIT table.I'm note sure that it is even a valid question. Because Livelink is stateless and there is no persistence from the web server to CGI connections it really means that a user is only connected for the duration of the time there request is being serviced.If you look at the Livelink server internals you will find that the user credentials are re-verified for each request (from the Livelink cookie).Typically this question is asked to understand the number of simulataneous users. That number can never be higher that the number of threads configured on the server.We have found that it is more useful to know the number of transactions through the server over a period of time (day/hour/minute).

Dave_Ebels_(jocoadmin_-_(deleted))

This is the SQL I use to capture users logging in for the last 20 min.select b.lastname, b.firstname, a.userid, to_char(a.auditdate, 'MM/DD/YY HH24:MI:SS')from daudit a, kuaf b where a.userid = b.id and a.event = 'LOGIN' and a.auditdate > sysdate - interval '20:00' minute to second order by b.lastnameset up as an 'Auto Livereport'It's about as good as we can guess at who is logged in at any given time. The time frame can be adjusted up or down as you like, just change the -- interval '20:00' minute -- appropriately.

Khalid_Omar

Hi Dave, your SQL code really helped me and thanks a lot. There are certain times it helps to know who is logged in and 20 mins past is as good as it can be.

David_Kim_(seamon01admin_-_(deleted))

Message from David Kim via eLinkI get an error when I run this.'to_char' is not a recognized function name.Thanks,David -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, January 21, 2005 2:11 PMTo: eLink RecipientSubject: I use this to capture the loginsI use this to capture the loginsPosted by Ebels, Dave on 01/21/2005 05:06 PMThis is the SQL I use to capture users logging in for the last 20 min.select b.lastname, b.firstname, a.userid, to_char(a.auditdate, 'MM/DD/YYHH24:MI:SS')from daudit a, kuaf b where a.userid = b.id and a.event ='LOGIN' and a.auditdate > sysdate - interval '20:00' minute to secondorder by b.lastnameset up as an 'Auto Livereport'It's about as good as we can guess at who is logged in at any giventime. The time frame can be adjusted up or down as you like, justchange the -- interval '20:00' minute -- appropriately.[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Who are the users logged in right now?https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3826605&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

Shafeeq_Hamza_(x-deptou01_-_(deleted))

For SQL Server I have modified the script as below:select b.lastname, b.firstname, a.userid, convert(char, a.auditdate) from daudit a, kuaf b where a.userid=b.id and a.event = 'LOGIN' and datediff(mi, a.auditdate, getdate()) <20 order by b.lastname

David_Kim_(seamon01admin_-_(deleted))

Message from David Kim via eLinkThank you for doing that. It works fine.Thanks,David-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, January 25, 2005 12:21 AMTo: eLink RecipientSubject: For SQL Server I have modified the script as belowFor SQL Server I have modified the script as belowPosted by Hamza, Shafeeq on 01/25/2005 03:16 AMFor SQL Server I have modified the script as below:select b.lastname, b.firstname, a.userid, convert(char, a.auditdate)from daudit a, kuaf b where a.userid=b.id and a.event = 'LOGIN' anddatediff(mi, a.auditdate, getdate()) <20 order by b.lastname[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Who are the users logged in right now?https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3826605&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

Rees_Williams

I was encouraged by this Livereport so we implemented itHowever we get a report of apparent multiple logins.I attache the Screen-shot.Is this an artifact or an indication that we have a problem ?Any suggestions ?Kevin(LL 9.2 , Oracle on Unix )

Dave_Ebels_(jocoadmin_-_(deleted))

When I run the report I often see the same thing. I was determined to make sure that what I was seeing was in fact happening. I use the 'Query Audit Log' from the admin pages to verify what I see in the report. In fact I use the 'Query Audit Log' so often I created a URL in my favorites for the function. I use it to verify logon activity when there is a question from a user. It's very helpful. Back to the question in hand ,, even though there seem to be duplicates in the report, I have been able to verify things with the utility I jut described. I do not think you are having a problem.Just one last tidbit, the string to add to the end of your Livelink URL (stored as a URL object in your personal workspace and made a favorite) goes like this ,,,,http:///livelink/livelink?func=admin.auditdsp&dbname=LIVELINK&subType=99&event=[All]&user=[All]If you have never used this utility, give it a shot, it is very useful. Identify the user ,,, ask for event type Login ,, and have at it. I hope this helps.By the way, I also am Oracle on Unix.Dave EbelsJohnson ControlsHolland, MI.616-394-2439

Gareth_Newell_(eu0014636user18_-_(deleted))

Alternatively if you are using sql server you can use this code Hope it helpsGarethSELECT b.name, b.lastname, b.firstname, a.userid, CONVERT(DATETIME, a.auditdate, 106) AS 'Login Time',DATEDIFF(MI,a.auditdate,GETDATE()) AS 'Minutes Logged In'FROM icr_user.daudit a INNER JOIN icr_user.kuaf b ON a.userid = b.id WHERE UPPER(a.event) = 'LOGIN' AND DATEDIFF(MI,a.auditdate,GETDATE()) <= 20ORDER BY b.name