Entitlement History for User Account

[BrandonLucas_BF]

Is there any part of the database schema that would allow querying for the history of an entitlement on a given user account? I'd like to see when an entitlement appeared on a user account during application data import.

[rushikeshvartak · Accepted solution]

You can find information in account_entitlements1 table, based on  job_id column but this column will be updated as per last import job execution

select distinct accountkey,entitlement_valuekey,job_id j,jobstartdate from account_entitlements1 ae1,ecmimportjob e where ae1.job_id=e.jobid and accountkey in (select accountkey from accounts where endpointkey =3)

https://saviynt.freshdesk.com/support/solutions/articles/43000521404-saviynt-enterprise-identity-clo... 

[BrandonLucas_BF]

Thank you.. I think this will get me where I need to be!