Report for user and entitlements

[NirajSaraf]

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?

[rushikeshvartak]

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