Analytics report about all the analytics and which SAV Roles can access them

[Community_User]

Originally posted on April 1 2022 at 10:00 UTC

Hi! 

Does anyone know that if it is possible in Saviynt to create a analytics report that collects data from all the analytics created & which SAV Role can access/view them? 

Or can this be done in some other way that is not manually check it one by one? 

This would be very helpful if there is anyway to collect that data easier & faster than the option B. 

Thank you! 

[Community_User · Accepted solution]

Originally posted on April 1 2022 at 15:30 UTC

Hello Wilma,

Here's something that might help.

Select s.ROLEKEY,s.ROLENAME,aes.ANALYTICSNAME 

from savrole_permission sp

join savroles s on s.ROLEKEY=sp.SAVROLEKEY

join analyticsconfiges aes on aes.ANALYTICSKEY=sp.ACCESSKEY;

Regards,

Avinash Chhetri

[Community_User]

Originally posted on April 4 2022 at 10:12 UTC

Hello,

Thank you for your help Avinash! Also this query does the trick: 

select ac.ANALYTICSKEY, ac.ANALYTICSNAME, ac.DESCRIPTION, ac.CATEGORY, (select rolename from savroles where rolekey = sp.savRolekey) as 'SAV ROLE NAME'   

from analyticsconfiges ac, Savrole_permission sp where sp.accesskey = ac.ANALYTICSKEY

Best,

Wilma