Inactive user report

Brian_Rourk_(rourk_-_(deleted))

Is there a way to list all users who have not used Livelink in the last 6 months?

Steve_McDonough

Brian,I use a report to check who has not logged into Livelink in the past 30 days. You can modify the logic in this query for 6 month. We run MS SQL so you will need to modify for Oracle if needed. Here is the select statement:select kuaf.firstname + ' ' + kuaf.lastname "Member Name", kuaf.name "Login Name" from kuaf where not exists (select userid from daudit where (userid = kuaf.id) and (event = 'LOGIN') and (auditdate < (getdate()-30))) and kuaf.deleted <> 1 and kuaf.type = 0 order by kuaf.lastnameReport format is naturally Auto LiveReportLeon