How to read entitlement history data? Missing entitlement_values_history table?

[AndNow]

Hi,

As solution from forum 

https://forums.saviynt.com/t5/identity-governance/how-to-read-entitlement-history-data/m-p/64654#M40...

doesn't work for me. How to get access to entitlement_values_history?

I am on 23.4 & 24.3 - bothe have the same issue.

regards

Andrzej

[PremMahadikar]

Hi @AndNow ,

That's right, this table is not being exposed (even for me in 23.10, but not the case for newer version as I can run it in 24.1)

Did you also try running the same from analytics report? It works there. Below are column values to query them in analytics: If this helps to build/customise your query.

For table related access in data analyser, please raise a freshdesk ticket.

If this helps your question, please consider selecting Accept as Solution and hit Kudos

[rushikeshvartak · Accepted solution]

Yes its not exposed in Data Analyzer 

Follow below steps from NEO UI

1. Search "Analytics Configuration List" from Left navigations
2. click on Create New analytics 
3. Select using SQL Query
4. Add below fields and click on Preview