Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/25/2023 01:31 AM
Hi Team,
Requirements are to be exported till node level(as per attached screenshot)
Solved! Go to Solution.
07/25/2023 11:52 PM
Hello @Narendrapranaam,
You can use the Export Feature under the transport for your use case,
Thanks
07/26/2023 04:50 AM
The export option will fetch the FEATURE_LIST and WEBSERVICE_LIST of what is assigned at the SAV Roles.
To get the associated Privileged_Access for these FEATURE_LIST as mentioned in the Snapshot earlier, please create an Analytics report with the below query and you will be able to fetch those details for ROLE_ADMIN.
select * from requestmap where CONFIGATTRIBUTE like '%ROLE_ADMIN%'.
07/26/2023 10:48 AM
@Narendrapranaam Here is a query you can use to get the feature name and the associated urls for a given SAV Role. You can change the sav role name at the end of the query and fetch the details for other sav roles as required. As @HK_bhaskar mentioned, you will have to create analytic reports for these
And, for the webservice access list, you can go to the sav role -> web service access tab and export the list. With these two lists combined you should be able to get the required details.
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_ADMIN';
Thanks,
Nagesh K
07/27/2023 12:39 AM
Hi Nagesh,
Tried to use your SQL query it works for most of the roles but unable to run for specific SAV_Role- "ROLE_CPAM_ROOTADMINREADONLY". Unsure if I'm running it incorrectly., used the revised query as below
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_ADMIN_ROOTADMINREADONLY'
Thanks!
Regards,
Naren
07/27/2023 01:31 AM
Hi @Narendrapranaam ,
Please let us know the error you are getting while executing the query for the SAV role "ROLE_CPAM_ROOTADMINREADONLY".
07/27/2023 01:42 AM
07/27/2023 01:47 AM
Hi @Narendrapranaam ,
In the query you mentioned ROLE_ADMIN_ROOTADMINREADONLY but you are trying to fetch ROLE_CPAM_ROOTADMINREADONLY.
Please execute below query and let us know the update.
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'
Regards,
Vikas J V
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.
07/27/2023 01:47 AM
07/27/2023 01:50 AM
Thanks Vikash, it was my mistake. Able to run the report.