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

1.2k Views Asked by At

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

2

There are 2 best solutions below

0
On BEST ANSWER
select ITRESOURCE_KEY from APP_INSTANCE where APP_INSTANCE_NAME ='<AppInstanceName>'
0
On

It resources keys are stored in table of SVR.

SELECT * FROM SVR