Hi Team,
Is it possible to get the count of distinct users logged into apex in last 2 days, day wise.
select DISTINCT TRIM(apex_user) FROM apex_workspace_log_summary_usr
WHERE apex_user NOT IN ('nobody', 'ANONYMOUS')
AND last_view >= TRUNC(SYSDATE);
Gives more than 1000 users.
When we use first_view, it gives 8o users, We will not have more than 200 users.
Please help us.
Thanks,
Satish