OIM - User password - List of users whose password got changed by whom and when.

Below is the query to find out the list of users whose password got changed by whom and when.

To get the details, you should log on to OIM schema and then run the below query.

SELECT A.USR_LOGIN AS USERLOGIN,

       A.usr_first_name,

      A.usr_last_name,

      A.usr_type,

      U.USR_LOGIN AS UPDATEDBY,

      to_char(A.PWH_CREATE,'dd/mm/yyyy hh24:mi:ss') as TIME FROM

      (SELECT U.USR_LOGIN,

            PWH_CREATEBY,

            u.usr_first_name,

            u.usr_last_name,

            u.usr_type,

            P.PWH_CREATE FROM PWH P,

           USR U WHERE P.USR_KEY= U.USR_KEY) A,

           USR U WHERE A.PWH_CREATEBY = U.USR_KEY AND A.PWH_CREATE > SYSDATE - 1;

This query list the users whose password got changed by whom and when for past 24 hrs.