DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, July 1, 2013

Apex Users Login's details

select WORKSPACE,APEX_USER,PAGE_NAME, trunc(VIEW_DATE) "Date", VIEW_DATE
 from APEX_040100.APEX_WORKSPACE_ACTIVITY_LOG
Where workspace in ('DOYEN')
AND trunc(view_date) = trunc(sysdate-1)
--and TRUNC(view_date) BETWEEN :From_date AND :TO_DATE
and page_name not in ('Page 1','zero','Oracle Application Express','Login','Application Builder')
and apex_user is not null
--and APEX_USER NOT LIKE '%ADMIN'
AND APEX_USER NOT IN ('DOYEN_DEV','nobody','DOYEN_ADMIN')
--AND APEX_USER like 'RAMYA'
order by view_date desc;

No comments: