How to get IT resource Key from OIM using SQL query?

1.2k Views Asked by Chaitanya K At 08 March 2017 at 12:22

To update child form lookup I need IT resource Key. Is there a SQL query for the same?

There are 2 best solutions below

Chaitanya K

Chaitanya K On 08 March 2017 at 12:23 BEST ANSWER

select ITRESOURCE_KEY from APP_INSTANCE where APP_INSTANCE_NAME ='<AppInstanceName>'

Furkan

Furkan On 06 October 2017 at 06:45

It resources keys are stored in table of SVR.

SELECT * FROM SVR