OIM – SQL Script to fetch who Revoked a Resource

Below query fetches the login name of the user who performs revocation on the OIM object :

select usr.usr_login, obj.obj_name, ost.ost_status, rev.usr_login “Revoker”
from oiu, usr, obi, obj, ost, usr rev
where oiu.usr_key=usr.usr_key
and oiu.obi_key=obi.obi_key
and obi.obj_key=obj.obj_key
and oiu.ost_key=ost.ost_key
and oiu.oiu_updateby=rev.usr_key
and ost.ost_status = ‘Revoked’

Leave a Reply

Your email address will not be published. Required fields are marked *