We have a requirement in which we have to generate a report containing account, entitlementname, when the entitlement was assigned, who approved the entitlement and all that. Does anyone have a sample query which can be used to get such analytics report?
You can get details from access_approvers , account_entitlements1 , entitlement_Values , accounts table.
Here getting approver for entitlement will not be easy as user can request entitlement n times hence approved by won't be correct
select a.name as account,ev.entitlement_value,ae.STARTDATE assignedwhen
from account_entitlements1 ae, entitlement_Values ev, accounts a where ae.entitlement_valuekey=ev.entitlement_valuekey and a.accountkey=ae.accountkey