Details regarding when entitlement got assigned to the account

[dgandhi]

Hi Team,

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.

Thanks

Devang

[pruthvi_t]

Hi @dgandhi ,

Greetings.

You can check the values in the 'startdate' column of account_entitlements1 table to check if it serves the purpose of your requirement.

https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...

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.

Thanks,

[dgandhi]

startdate is not holding any value so unfortunately this column doesnt help.

[rushikeshvartak]

JOBID column can determine when entitlement got assigned to account but it will be updated after every import.  

Please submit idea ticket