Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

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

thesvg
Regular Contributor
Regular Contributor

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.

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

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

rushikeshvartak_0-1716433546171.png

 

 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.