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!

I need a SQL query which can give the list of users created in OIM in last 1 hour

1622250Oct 31 2014 — edited Nov 4 2014

Hi,

We have a GTC configured to create users in OIM using trusted recon from an adp feed file.Now we need a query which can give the number of users created in last 1 hour.

In USR table I can see that there is a column called USR_CREATE which contains the date on which the user is created.But it does not store the time stamp.Is there any other table or way by which we can get the list of users created in OIM last 1 hour.

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2014
Added on Oct 31 2014
#identity-management, #identity-manager
20 comments
1,495 views