Security Software

Hi Experts,

Need very urgent inputs from you all for the preparation of our audit.

We are using OIM9.1.0.1

We need to know the sqlquery for finding the Disabled date in OIM given the user ids, as currently we are unable to get the exact data from Historical Reports Option in OIM.

I need to give in this format:
*************
select usr_login, usr_disabled from schemaname.tablename where usr_login in
('aaa','bbb'..... etc)

We have three attributes :USR_DISABLED_BY_PARENT,USR_DISABLED,USR_DEPROVISIONING_DATE,but none of them give the exact date,
USR_DISABLED gives just a flag as 1 or 0.

Also there are no other fields in the corresponding usr table.

So how to fetch the exact Disabled date from OIM system when I input the user ids.

Your immediate response is appreciated.

Thanks
SS