nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

determining actual number of users per day

Josephine_Bush

Hi,

I am trying to get an accurate count of the number of users that access our livelink system. It appears that it is logging pretty much every user that has an account as actually logging into the system daily, but this is not the case. We have many users overseas that are certainly not accessing the system daily, but that are audited as logging into the system. How can I get a truly accurate count of the users accessing the system?

I've tried using this query - and it returns 519 logins for today - and there is no way that all those people logged in.

SELECT DISTINCT UserID , FirstName , LastName , AuditStr

FROM ll9501 . DAuditNew a , ll9501 . KUAF k

WHERE AuditDate > '2012-03-29'

AND AuditStr = 'login'

AND k . id = a . UserID

ORDER BY LastName

I contacted OT support about this and received this answer:
Livelink does not track active or current logins as we use session less connections, which means each request is handled as it comes in. Livelink works in a state-less environment. As a result, it is not possible to tell if someone is presently logged in. Technically, the only time a person is logged into Livelink is when a request is being processed. Once the request is completed, they are no longer "in" Livelink as such.

I really think that there must be some way of telling who is truly accessing the system. Hopefully someone has an idea.

Thank you,
Josephine

Find more posts tagged with

Comments

Lindsay_Davies

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Hi,

The formatting of your SQL statement has been broken in this posting.

I suspect there is something wrong with the statement when you execute it.

What database are you using? Oracle or SQL Server?

The AuditStr value is mixed case. 'Login'

If you are using theDirectory Services module and have integrated authentication, there will not be a Login event.

If the cookie has not expired and the browser is left open, a user may work across more than one calendar day without logging in anyway.

If you want to know the active users (i.e. who did anything) in the system in the last 24 hours, for example, I would run the following statement.

Note, PerformerID is the column to check as UserID may not relate to the person who did something, rather the person being done to - like being added to a Group.

Oracle:

select ID , FirstName , LastName from Kuaf where ID in (select distinct(PerformerID) from DAuditNew where AuditDate > sysdate-1)

SQL Server:

select ID , FirstName , LastName from Kuaf where ID in (select distinct(PerformerID) from DAuditNew where AuditDate > getdate( ) -1)

Regards

Lindsay

Lindsay Davies

EU Escalation Team

OpenText UK

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 March 29, Thu 23:00
To: eLink Recipient
Subject: determining actual number of users per day

determining actual number of users per day

Posted by josephine.bush@res-americas.com (Bush, Josephine) On 03-29-2012 17:55

Hi, I am trying to get an accurate count of the number of users that access our livelink system. It appears that it is logging pretty much every user that has an account as actually logging into the system daily, but this is not the case. We have many users overseas that are certainly not accessing the system daily, but that are audited as logging into the system. How can I get a truly accurate count of the users accessing the system?I've tried using this query - and it returns 519 logins for today - and there is no way that all those people logged in.SELECTDISTINCTUserID ,FirstName ,LastName ,AuditStrFROMll9501 .DAuditNew a , ll9501. KUAF kWHEREAudit! Date >'2012-03-29'ANDAuditStr ='login'ANDk .id =a ! . UserIDORDERBYLastNameI contacted OT support about this and received this answer:
Livelink does not track active or current logins as we use session less connections, which means each request is handled as it comes in. Livelink works in a state-less environment. As a result, it is not possible to tell if someone is presently logged in. Technically, the only time a person is logged into Livelink is when a request is being processed. Once the request is completed, they are no longer "in" Livelink as such. I really think that there must be some way of tell! ing who is truly accessing the system. Hopefully someone has an idea.Thank you,
Josephine

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Colin_Schmidt

I found this in the KC last year. It lists all Users who have had activity in the given day by the Hour, so you can see what hours each particular User was active across the 24 hour period. If their profiles are setup to differeniate time zones, you could customize it to take that into consideration.

HourlyActivity.sql

HourlyStats.sql

Josephine_Bush

Hi,

I'm using SQL Server -- these appear to be Oracle.

Thanks,
Josephine

Josephine_Bush

Hi Lindsay,

I guess my real issue is that there are users that the audit trail is showing as accessing the system, but they are most certainly not accessing it daily like the audit trail shows. It seems like OT audit trail is showing they are using Livelink when they are logging into their computer or something else that is thinking that they are accessing Livelink.

The query you provided gives me a similar result to my own query, and I wind up with a list of 500 some users that accessed the system in the last day. We know that all these people are not specifically accessing Livelink. Is there a way that they are logged as using it if they just log onto their computer or something like that?

Thanks,
Josephine

Nicole_Bride

Josephine,

What actions do you consider “accessed”? Are you more interested if they performed a search or viewed a document, rather than just opening it?

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, March 30, 2012 4:08 PM
To: eLink Recipient
Subject: RE determining actual number of users per day 2

RE determining actual number of users per day 2

Posted byjosephine.bush@res-americas.com (Bush, Josephine) On 03-30-2012 16:06

Hi Lindsay,

Thanks,
Josephine

[To post a comment, use the normal reply function]
Topic:	determining actual number of users per day
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Appu_Nair

You could definitely see something of that sort but not linited to some of these examples are "ghost like livelink " entries.

The corporate mandates everybody visit a portal for something.inside the portal is a link to a specific location in livelink.If the page loads and SSO(dir svcs authentication) is enabled the user may not think he/she is making a login but the call hits the database and gets recorded.

If livelink explorer desktop folders are there users could still make a login while just firing up their computer.

In short the livelink server records login when the user makes a login and no cookie is present to the user's browser or when REMOTE_USER is not available.

Before the livelink application can be gotten on a web sense you have to first hit the livelink webserver.If you download logparser from microsoft and get the livelink webserver logs you can cross check all those ghost user's based on their ip address.

I would bet that the time of the login in livelink is msecs after the call hits the webserver.

In OOTB livelink nobody can request a resource if a usersession is not created.A usersession is created on initial login and will die on expiration parameters etc.

Truly speaking the login event in livelink cannot be used to understand who did what in livelink.It is based on other auditable events.

Some of my random thoughts here

Josephine_Bush

Hi,

Yes, I am definitely more interested in what they are doing including viewing documents and doing searches.

Thanks,
Josephine

Josephine_Bush

Hi,

I think this is the query that will work for my purposes:

select ID , FirstName , LastName

from ll9501 . Kuaf

where ID in ( select distinct ( PerformerID ) from ll9501 . DAuditNew

where AuditDate > getdate ( ) -1 AND auditstr NOT IN ( 'login' , 'attrchange' ))

ORDER BY LastName