Quick “Report” of all OIM Open Tasks

Posted by Unknown on Tuesday, April 19, 2011

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′

More Here


{ 0 comments... read them below or add one }

Post a Comment