How to read entitlement history data?

[Sampo]

Hi,

some entitlement rank 1 owners information got lost from a number of applications. The ownership information was stored in child entitlements in AD child endpoints and we've found out that with the latest releases the rank 1 entitlement owners need to be stored in the parent entitlements, otherwise the next access import from AD will remove it.

However, the information can be still seen in the entitlement history tab, so it's stored in the Saviynt database. How can we read this information from db, so that the correct owners can be restored? I haven't found information on which table Saviynt uses to store entitlement history, including previously added owners.

best regards,

Sampo

[dgandhi]

Check below table to fetch old owner details:

Column Name:oldvalue

[rushikeshvartak · Accepted solution]

Even though you map again it will be removed again hence add sav4sav connector to move entitlement owner from parent endpoint entitlement to child endpoint entitlements 

This is current known issue

Query :

select e.entitlement_value,h.newvalue,h.oldvalue,h.operation,h.createdon from entitlement_values_history h,entitlement_values e where e.ENTITLEMENT_VALUEKEY=h.ENTITLEMENT_VALUEKEY and h.changedField='Owner'

[Sampo]

Thanks a lot @rushikeshvartak , I was able to run the query with analytics. Yes, we are now setting the owners to parent entitlements, though it's still unclear why setting rank 1 owners to child entitlements was working in previous releases (up to 23.5) but not with the latest ones.

best regards,

Sampo