PSACCESS LOG AUDIT SCRIPT

select A.OPRID,B.OPRDEFNDESC,A.LOGIPADDRESS,A.LOGINDTTM,A.LOGOUTDTTM,A.PT_SIGNON_TYPE from PSACCESSLOG A,
PSOPRDEFN B where LOGINDTTM > '01-JAN-2018' and A.OPRID=B.OPRID and A.PT_SIGNON_TYPE <> 1 order by A.LOGINDTTM desc ;