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

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,