Quick “Report” of all OIM Open Tasks

Here’s a quick SQL script that’ll list out all the open tasks with their login, date, and details:

select oti.sch_actual_start,oti.sch_data,usr.usr_login from oti inner join orc on oti.orc_key=orc.orc_key inner join usr on orc.usr_key=usr.usr_key where oti.sch_actual_start>’15-AUG-10′

The filter in this script (where oti.sch_actual_start>’15-AUG-10′) is just to list all tasks that have occurred after the 15th.

.: Adam

OIM 11g is Available for Download!

Go get it! I’m downloading it right now =) Follow this link for the download: http://www.oracle.com/technetwork/middleware/downloads/oid-11g-161194.html Scroll down and select Oracle Identity and Access Management ( This download will include: Access Manager Adaptive Access Manager Identity Navigator Identity Manager Platform Security Services Authorization Policy Manager You can get all the 11g connectors here: http://www.oracle.com/technetwork/middleware/id-mgmt/downloads/connectors-101674.html Cheers!…