list and count users, that they not logged in (are inactive) content server since 180 days

Hello,

can anyone help us. We need a livereport, that can list and count users, that they not logged (are inactive) in content server since180 days.

We have content server 10 and oracle db.

Thx

Martin

Find more posts tagged with

Comments

Rinita_Pranaykanti

Please find similiar queries @ https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=30366122&objAction=viewincontainer

Regards

Rinita

Martin Matusik

Hi Rinita,

but in this issue i've looked before and i was testing it. And it shows me not exactly users that are not logged in since 180 days but it shows more users these were logged in last time. Our Users use Windows authentification. And some of it not.

Lindsay_Davies

Hi Martin,

Livelink / Content Server runs as a stateless application in the web browser.

You can have Livelink authenticated users who really log in at a login page and integrated users whose credentials are passed in from the web server sat on the same domain.

So checking for a Login event is not the best way to determine who was using the system.

However, bear in mind that any approach taken will only show results based on what events are configured to be audited.

If you do not have many of the possible events enabled then your results will not be very realistic.

Here are some modified queries you might find more useful.

As you have not said whether you use Oracle or MSSQL I have included statements for both.

Oracle:

/* users who have not used the system in the past 180 days */

select firstname, lastname, name

from kuaf where type = 0 and deleted = 0 and id not in

(select distinct(performerid) from dauditnew where auditdate > sysdate - 180)

MSSQL:

/* users who have not used the system in the past 180 days */

select firstname, lastname, name

from kuaf where type = 0 and deleted = 0 and id not in

(select distinct(performerid) from dauditnew where auditdate > getdate() - 180)

Regards

Lindsay

European Escalation Team

Opentext UK

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 November 13, Tue 11:01
To: eLink Recipient
Subject: list and count users, that they not logged in (are inactive) content server since 180 days

list and count users, that they not logged in (are inactive) content server since 180 days

Posted bymartin.matusik@dguv.de (Matusik, Martin) On 11-13-2012 05:56

Hi Rinita,

[To post a comment, use the normal reply function]
Topic:	list and count users, that they not logged in (are inactive) content server since 180 days
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center