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