Click HERE to see how Saviynt Intelligence is transforming the industry. |
12/05/2023 06:09 AM
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
Solved! Go to Solution.
12/05/2023 06:38 PM
Check below table to fetch old owner details:
Column Name:oldvalue
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.
12/05/2023 06:45 PM
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'
12/06/2023 11:00 PM
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