Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Need to fetch the assignee name for the pending request in a analytics report

Debankita
New Contributor III
New Contributor III

Hi Team,

I want to configure an analytics report of all the pending approvals along with the assignee names with whom the requests are pending.

Please help me by suggesting how to fetch the assignee's name in the analytics report

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

select ar.REQUESTKEY,u.username as REQUESTOR,ar.REQUESTDATE ,a.username as approvername
from ars_requests ar join request_access ra on ra.requestkey=ar.requestkey join access_approvers aa on aa.request_access_key=ra.request_accesskey join users u on u.userkey = ar.REQUESTOR join users a on aa.approverkey=a.userkey where ar.status in (1) and aa.status = 1

 

access_approvers table contains approval related information

For other tables information refer https://saviynt.freshdesk.com/support/solutions/articles/43000521404-saviynt-enterprise-identity-clo... 


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