09/12/2022 03:13 AM
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
09/12/2022 06:08 AM
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...