OIM Important Queries.

User Details:

• select * from USR where UPPER(usr_login)='username'

AUDIT: 

• select * from dev_oim.UPA_FIELDS UPA_FIELDS LEFT outer JOIN dev_oim.upa_usr  upa_USR ON upa_fields.upa_usr_key=upa_USR.UPA_USR_KEY where UPPER(upa_usr.usr_login) like 'userlogin'

Resource Audit: 

• select * from dev_oim.UPA_RESOURCE

Plugins Info: 

• select * from dev_oim.plugins

Audit Table: 

•   select * from dev_oim.UPA where usr_key='userkey' order by upa_key desc

Jar file: 

• select * from dev_oim.oimhome_jars

Plugins:

•   select * from dev_oim.plugins