We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

How to read entitlement history data?

Sampo
New Contributor III
New Contributor III

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

3 REPLIES 3

dgandhi
All-Star
All-Star

Check below table to fetch old owner details:

Column Name:oldvalue

 

dgandhi_1-1701830301228.png

 

 

 

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

rushikeshvartak
All-Star
All-Star

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'

rushikeshvartak_0-1701830706442.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Sampo
New Contributor III
New Contributor III

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