Andrew Fraser DBA

Atira Pure Research – List Users by last activity

List out users by last activity in Atira’s Pure Research Information System with:

SELECT a.username ,
       u.name_first_name forename ,
       u.name_last_name surname ,
       TRUNC ( MAX ( a.entry_date ) ) last_audit_entry
  FROM audit_entry a ,
       users u
 WHERE a.username = u.username(+)
 GROUP BY a.username ,
       u.name_first_name ,
       u.name_last_name
 ORDER BY 4 , 3 , 2 , 1