Hi,
I’m seeking info on querying the last log-in details of Aurena users. (In other words, I need to see the users how rarely use the system or less active in the system). I used the following query to get the DBA users who logged into IFS for past 6 months. But that does not show the Aurena users. Is there a specific table that store all end users?
SELECT *
FROM dba_users ul
WHERE last_login >= SYSDATE - 180;
Kind regards,
Tharindu