Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/11/2024 07:52 AM
Hello,
I need to assign a SAV role to all the managers inside our organization.
Is there an easy way to do that? I can't find an answer for that topic in the forum.
04/11/2024 08:47 AM
Please enable the Saviynt4Saviynt from configurations, this would allow you to manage Saviynt as an application.
Use Sav4Sav to import SAV roles as entitlements into EIC. Then use Technical Rule to assign the SAV role entitlement to managers.
04/11/2024 08:12 PM
Use Actionable Analytics Report
SELECT ev.ENTITLEMENT_VALUEKEY AS entvaluekey, ev.ENTITLEMENT_VALUE AS rolename, a.ACCOUNTKEY AS acctKey, a.NAME AS accName, u.USERKEY AS userKey, u.USERNAME, u.EMAIL, CONCAT(u.FIRSTNAME, " ", u.LASTNAME) AS user_name, u.CUSTOMPROPERTY4 AS 'Career Level Code', u.EMPLOYEETYPE, 'Provision Access' AS 'Default_Action_For_Analytics'
FROM
ACCOUNTS a, USERS u, USER_ACCOUNTS ua, ENDPOINTS e, ENTITLEMENT_TYPES et, ENTITLEMENT_VALUES ev
WHERE a.ACCOUNTKEY = ua.ACCOUNTKEY AND u.USERKEY = ua.USERKEY AND e.ENDPOINTKEY = a.ENDPOINTKEY AND et.ENDPOINTKEY = e.ENDPOINTKEY AND et.ENTITLEMENTTYPEKEY = ev.ENTITLEMENTTYPEKEY AND ev.ENTITLEMENT_VALUE = 'ROLE_MANAGER' AND ev.STATUS = 1 AND u.STATUSKEY = 1 AND e.ENDPOINTNAME = 'Saviynt'
AND a.STATUS NOT IN ( 'SUSPENDED FROM IMPORT SERVICE' ) AND u.USERKEY NOT IN (SELECT US.USERKEY FROM USER_SAVROLES US,SAVROLES S WHERE US.ROLEKEY = S.ROLEKEY AND S.ROLENAME='ROLE_MANAGER') AND AND u.EMPLOYEETYPE = 'Employee'