You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI 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

edited Dec 3, 2024 3:12PM in Reporting and Analytics for HCM 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!