Trying to get a list of users that has not logged in

Cheryl_Henry_(nswcdahladmin_-_(deleted))

I am trying to get a list of users that has not logged into Livelink in a certain about of time. This is the SQL that I have, "select distinct firstname, lastname, contact from daudit, kuaf where kuaf.id not in(select daudit.userid from daudit where (SysDate-auditdate)<(Sysdate - to_date(%1)))"I have tested this on our test server with only 10 userid's and it works o.k.. However, when I try to run the report on our production server (with several hundred users) the report will set for so long that I never let it complete.How can I improve this report so I can get a list of all users that has not logged in, let's say in the last 30 days? Has anyone done this?

Gerhard_Spoetzl_(ap_gspoetzl_(Delete)_454659)

Please try the following statementselect firstname, lastname, contact from kuaf where not exists (select userid from daudit where (userid = kuaf.id) and (event = 'LOGIN') and (auditdate < Sysdate-30))for users that haven't logged since 30 daysI did this on a CRACLE 8.0.3.0.0 DB.