SQL Query to get Process Instance Key of particular Resource for user in OIM

 Query to get Process Instance Key:

SELECT ORC_KEY FROM ORC,PKG,USR WHERE ORC.PKG_KEY=PKG.PKG_KEY AND ORC.USR_KEY=USR.USR_KEY AND PKG_NAME=’[Insert Resource Name here]’ AND USR_LOGIN=’[Insert User Login here]’; Example: To get Process Instance Key of AD User resource for TESTUSER user: SELECT ORC_KEY FROM ORC,PKG,USR WHERE ORC.PKG_KEY=PKG.PKG_KEY AND ORC.USR_KEY=USR.USR_KEY AND PKG_NAME='AD User' AND USR_LOGIN=’TESTUSER’;