Account/Entitlement created directly in the endpoint

[Community_User]

Originally posted on September 9 2020 at 11:36 UTC

Hi

How can we create an analytics for the accounts/entitlements created directly in endpoint. E.g. AD.

When we run the import access and/or import accounts jobs against the target systems, the start date column is not getting updated in the account_entitlements1 table for the entitlements created directly in endpoint. And updatedate is always set to today's date.

I want to know the accounts/entitlements created in last 7 days or 1 month.

Thanks,

Ayush Jain

[Community_User · Accepted solution]

Originally posted on September 9 2020 at 23:58 UTC

Hi Ayush,

Any account/entitlement created outside of saviynt will not have the arstaskkey column populated, so you can write a query like below

select accountkey,entitlement_valuekey from account_entitlements1 where arstaskkey is null;

Thanks,

Aarthi