01-18-2023 05:00 AM
Is there a way to get list of users who qualify for BR technical rules based on the basic or advanced conditions that are configured in rules.
For example -
User attributes - state = test, country = abc, location = test1
BR Tech Rule - a.state=test and a.country=abc and a.location = test1
As the user qualifies the tech rule, the query/report should show user and tech rules which he qualifies for BR process.
As the advanced conditions are stored as string in the hanarule table, you cannot equate this in any where clause. Tried using dynamic variables / session variables, but the db vizualiser or analytics does not support it.
Is there a way to get such list using existing (supported) SQL capabilities of Saviynt ?
01-18-2023 05:03 AM
01-18-2023 07:31 AM
type = 1 AND status = 0
AND hanarulekey = 820;
@sqlstring:=CONCAT('SELECT userkey,username,firstname,lastname,email,secondaryemail,statuskey,systemusername FROM users WHERE ',
PREPARE sqlquery FROM @sqlstring;
DEALLOCATE PREPARE sqlquery;
This is not fully formed, but was trying something similar to this.
01-18-2023 07:40 AM
01-18-2023 08:03 AM
I do not want to take this approach only as storedprocs maintenance etc is overhead. Thats why checking if there is any other simpler solution anyone built
01-18-2023 08:04 AM
01-18-2023 08:59 AM
advancequery in hanrule is stored as a string value, you cannot equate it or execute it directly to fetch matching users.