Export Sav Role and endpoint url

[zzz1qaz]

Solved: Need feature access export for listed SAV Roles - Saviynt Forums - 45352

above document shows how to export sav role and the feature_list/webservice_list names, but not url

how to get the url for the feature_list/webservice_list for a sav role??

"FEATURE_LIST":
[
"Home",
"SOD_Function_Change_Requests"
],
"WEBSERVICE_LIST":
[
"pmgmt_passwordResetAPIUser",
"pmgmt_resetAPIUserPassword",
"webservice_api_authenticateUser",
"api_v5_fetchRuntimeControlsData",
"webservice_api_v5_authenticateUser",
"api_v5_fetchRuntimeControlsDataV2",
"apiv5fetchCertificationList"
]

[zzz1qaz]

all good, I can export access list with url then link them

[rushikeshvartak]

Did you tried query suggested in forum 

https://forums.saviynt.com/t5/privileged-access-management/need-feature-access-export-for-listed-sav...

select sv.ROLENAME, fr.FEATUREDISPLAYNAME, rm.url from requestmap rm inner join requestmap_feature rmf on rm.AUTHTYPE = rmf.AUTHTYPE inner join feature fr on fr.FEATURENAME = rmf.FEATURENAME inner join savrole_feature svf on svf.FEATUREID = fr.FEATUREID inner join savroles sv on sv.ROLEKEY = svf.ROLEKEY and sv.ROLENAME ='ROLE_CPAM_ROOTADMINREADONLY'