Skip to Main Content
Forums

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL query to get the all the recon events of a particular user

user8744020Dec 28 2016 — edited Dec 29 2016

Hi,

We are on 11gR2 PS2.

I need to search for  users recon events every day to do some comparison. Generally, i go to the OIM sysadmin console, reconciliation events and search based on the key field. but, it's a lengthy process and time consuming too.

could you please help me with the SQL query, where in we can get all the recon events of that users based on the profile name( AD User, Flatfile etc), with which user it has been linked.

I was able to get the table name, which is recon_events.

any help would be greatly appreciated.

Thanks,
This post has been answered by Satish Kurasala on Dec 28 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2017
Added on Dec 28 2016
#identity-management, #identity-manager
8 comments
2,182 views