schema info for tech rule / user update rule update history

[ejeong]

Hello, 

I need to provide entire update history for tech rule / user update rule to audit team. 

Could you please confirm what table name is containing these info?

Thanks

[armaanzahir]

Hi @ejeong ,

The table name is hanarulehistory.

select hanarulekey,oldvalue,newvalue,olddesc,newdesc,requestedby,requestedon,requestid,requeststatus,approvedon,approvedby,approvercomments from hanarulehistory;

This is not exposed in data analyzer or is present in the Saviynt Documentation.

You might require a join with the hanarule table to fetch the rule name.