Can we get an extract of all the current technical rules and the respective birthright entitlements?

[bleeb]

Hi everyone,

Is there an OOTB way to extract all the current technical rules and the respective birthright entitlements?

Thanks,

Brandon.

[RakeshMG]

The similar request is already raised as an enhancement request, please refer to  : https://ideas.saviynt.com/ideas/EIC-I-3369

[Paul_Meyer]

As mentioned, there is currently no ootb feature available to export Technical/User Update Rules.

To create an export, you could create Analytics report(s) to extract the table data from HANARULE and HANARULEATTRIBUTE tables. From there export the report results into a local MySQL instance, for example,  and create SQL queries to extract the data. Such as into JSON.

There is a feature to upload Technical Rules, but seems to "not currently working as expected" according to the Note section.

So your mileage might vary.

[dgandhi]

No OOTB way but as alternative you can use below query and check if that helps.

SELECT hr.Name AS 'User Update Rule Name',hr.RULEDESCRIPTION AS 'User Update Rule Description',(select hr1.name from hanarule hr1 where hanarulekey=
REPLACE(TRIM(SUBSTRING(SUBSTRING_INDEX(hra.objectvalue, ',', numbers.n),
LENGTH(SUBSTRING_INDEX(hra.objectvalue, ',', numbers.n - 1)) + 1)),',','')) AS 'Technical Rule Name'
FROM hanarule hr
JOIN hanaruleattribute hra ON hr.hanarulekey = hra.hanarule
JOIN (SELECT 1 n UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4
UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8
UNION ALL SELECT 9 UNION ALL SELECT 10) numbers ON CHAR_LENGTH(hra.objectvalue) - CHAR_LENGTH(REPLACE(hra.objectvalue, ',', '')) + 1 >= numbers.n
WHERE hra.conditionoraction LIKE 'ACTN'
AND hr.type = 2
AND hra.objectname = 21
AND hr.name LIKE '%RBAC%'
AND hr.status=0
ORDER BY hr.Name ASC, CAST(`ObjectValue` AS UNSIGNED) ASC;

Thanks