Need feature access export for listed SAV Roles

[Narendrapranaam]

Hi Team,

Need export of feature permission for list of SAV Roles as below, 

1. ROLE_ADMIN
2. ROLE_ADMIN_SAVIYNTSUPPORT
3. ROLE_CPAM_AUDITOR
4. ROLE_CPAM_ENDUSER
5. ROLE_CPAM_ROOTADMINREADONLY
6. ROLE_CPAM_SUPPORTADMIN

Requirements are to be exported till node level(as per attached screenshot)

[sudeshjaiswal]

Hello @Narendrapranaam,

You can use the Export Feature under the transport for your use case,

For Ref :- https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter07-General-Administrator/Exp... 

Thanks

[HK_bhaskar]

Hi @Narendrapranaam 

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%'.

[NageshK]

@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

[Narendrapranaam]

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

[vikasjv]

Hi @Narendrapranaam ,

Please let us know the error you are getting while executing the query for the SAV role "ROLE_CPAM_ROOTADMINREADONLY".

[Narendrapranaam]

Hi Vikash,
I'm not getting any error but I receive 0 logs/records.
Thanks!
Regards,
Naren

[vikasjv · Accepted solution]

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.

[Narendrapranaam]

Attaching the message from History for the record ran with 0 entry

[Narendrapranaam]

Thanks Vikash, it was my mistake. Able to run the report.