Analytics config to see Assigned privileges for all users and the assignment method (role/adhoc)

[theosveg]

I'm looking to develop a report that shows the privileges assigned to all users and how they were assigned. Specifically, I'd like to know if the privileges were assigned via a role or through other methods like birthright or ad hoc access requests. Do you have any insights or suggestions on how I could go about creating this report? Thank you.

[rushikeshvartak]

SELECT a.name,ev.entitlement_Value ,at.source
FROM accounts a
JOIN account_Entitlements1 ae ON ae.accountkey = a.accountkey
JOIN entitlement_Values ev ON ev.entitlement_Valuekey = ae.entitlement_Valuekey
LEFT JOIN arstasks at ON ae.ARSTASKKEY=at.taskkey
WHERE a.endpointkey = 3
AND a.name = '137658'
AND ev.entitlementtypekey = 5