PeopleSoft Audit script

 select * from psaccesslog  where oprid in ('FSBATCH','FSMONITOR','PSAPPS','PTWEBSERVER','OPERATOR','VP1','PS') and logindttm >= to_date('AUG-28-2017','MON-DD-YYYY') and logindttm <= to_date('SEP-02-2017','MON-DD-YYYY') order by LOGINDTTM DESC