Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
User All Login Details within a specific period
Hello Experts,
Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details.
However, is it possible to get through SQL/any other reports all login details for the user prior to 1st Nov. as well.
SELECT
U.USERNAME,
to_char(U.CREATION_DATE,'dd-mm-yyyy') CREATION_DATE,
to_char(A.LAST_LOGIN_DATE,'dd-mm-yyyy') LAST_LOGIN_DATE
FROMASE_USER_LOGIN_INFO A,PER_USERS U
WHERE A.USER_GUID =U.USER_GUID
AND U.USERNAME NOTLIKE 'FUSION_APPS_%'
ANDA.LAST_LOGIN_DATE IS NOT NULL
ANDA.LAST_LOGIN_DATE > sysdate - 60
Tagged:
0