LiveReport to show User logins

Firaz_Alyas

Please can someone advise how I can report on users that have not logged in for say 6 months.

I can query the auditdate in dauditnew to find out when the user last logged in but not sure how I can do the above.

Thanks,

Fraz

Find more posts tagged with

Comments

Bhupinder_Singh

Please see here:

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=12473635&objAction=viewincontainer&ShowReplyEntry=12475615#forum_topic_12475615

- Bhupinder

Mike_Davis

We had this LiveReport in our 971 system (sql) set the report format to auto LiveReport;

select DAuditNew.AuditDate, KUAF.FirstName, KUAF.LastName from DAuditNew, KUAF where

DAuditNew.PerformerID=KUAF.ID and DAuditNew.AuditStr='Login' order by DAuditNew.AuditDate desc

It lists all login events ever, by first and last name, so although it doesn’t exactly give a list of users not logged in for 6 months, you could compare this to a list of users in your system, knock out the users who have logged in during the last 6 months, then you have your answer.

Mike

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 24 April 2013 16:07
To: eLink Recipient
Subject: LiveReport to show User logins

LiveReport to show User logins

Posted byfalyas@buckscc.gov.uk (Alyas, Firaz) On 04-24-2013 10:37

Please can someone advise how I can report on users that have not logged in for say 6 months.

I can query the auditdate in dauditnew to find out when the user last logged in but not sure how I can do the above.

Thanks,

Fraz

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

Firaz_Alyas

Thanks guys