OIM DB SQL

Direct SQL To the OIM Database. Your Mileage May Vary

Looking At Adapter Info

select
adp_name,
evt_name,
adt_name,
adt_type,
--adj_api_name,
adj_method,
--adj_constructor,
adj_method_display,
adj_jar_file
from adt,adp,evt,adj
where
adt.adp_key=adp.adp_key and
adp.evt_key= evt.evt_key and
adj.adt_key=adt.adt_key 
--and adj_method_display like '%boolean%'
order by adp_name

Looking at IT Resource Info

SVR - IT Resource
SVD - IT Resource Type
SPD - IT Resource Field Name -> SVD
SVP - IT Resource Values  -> SVR,SPD
 
select 
r.svr_key as ITResNameKey,
r.svr_name as ITResName,
t.svd_key as ITResTypeKey,
t.svd_svr_type as ITResType,
n.spd_key as ITResFieldNameKey,
n.spd_field_name as ITResFieldName,
v.svp_key as ITResFieldValKey,
v.svp_field_value as ITResFieldVal
from svr r,svd t,spd n,svp v
where 
v.svr_key = r.svr_key and
v.spd_key = n.spd_key and
t.svd_key = n.svd_key
order by r.svr_name

Update the version of a form so all existing forms now use the new version.

update UD_ADUSER set UD_ADUSER_VERSION=(select sdk_active_version from sdk where sdk_name='UD_ADUSER')

Find Child Event Tasks

   select mil_key, pkg.pkg_name,mil_name,mil_trigger_type,mil_child_table_name
   from mil,tos,pkg
   where mil.tos_key = tos.tos_key
   and tos.pkg_key = pkg.pkg_key
   and mil_trigger_type is not null
   order by pkg_name,mil_name

Undo a Child Event Trigger

   update mil set mil_trigger_type=null,mil_child_table_name=null where mil_key=yourtasksmilkey