We have few DB based application where we are performing account and entitlement full import.
We want to find when the entitlement was first assigned to an account. Is there any column or DB attribute which will provide this information.
We checked JOBID column in the account_entitlement1 table but it seems JOBID will be updated when we do FULL Recon. Do we have any other attribute which will provide us with relevant information.
Hi @dgandhi ,
You can check the values in the 'startdate' column of account_entitlements1 table to check if it serves the purpose of your requirement.
If it doesn't work, please check if you can get the date an entitlement is assigned to the account from target application's table and import it into one of the Saviynt's custom properties.