Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.
No ratings
DixshantValecha
Saviynt Employee
Saviynt Employee

Use Case:

SOD Report with Entitlement Owner Details of the PARENT ROLE (USER SPECIFIC)

Pre-requisites:

  • Access to Saviynt environment.
  • Knowledge of SQL query execution.

Solution: This solution provides a SQL query to enhance the standard SOD report generated from the UI. The modified report includes detailed information about parent role conflicts, function associations, and entitlement owner details.

Problem Statement: The standard SOD report exported from the UI lacks comprehensive information about parent role conflicts, function associations, and entitlement owner details. This enhanced report aims to address this limitation.

Solution Steps:

Step 1: Export Enhanced SOD Report:

  1. Problem: Standard UI-exported SOD reports lack detailed parent role and entitlement owner information.
  2. Solution: Use the SQL query provided below to export an enhanced SOD report.

Example SQL Query:

SELECT DISTINCT RULESET, RANK, ENTITLMENT_OWNER, ENTITLEMENT_OWNER_DISPLAYNAME, USERNAME, DISPLAYNAME, USER_STATUS, HR_STATUS, JOBDESCRIPTION, DEPARTMENTNAME, LOCATION, MANAGER_USERNAME, MANAGER_EMAIL, ACCOUNT_NAME, ACCOUNT_STATUS, RISKCODE, RISK_PRIORITY, FUNCTION_1, PARENT_ROLE, FUNCTION_2, ENTITLEMENT_VALUE AS 'PARENT_ROLE_CONFLICTING', SOD_STATUS, MITIGATINGCONTROL FROM (SELECT DISTINCT RULESET, t5.SODKEY, entitlement_owners.RANK, users.USERNAME AS ENTITLMENT_OWNER, users.DISPLAYNAME AS ENTITLEMENT_OWNER_DISPLAYNAME, ... -- Rest of the query, as provided ) FINAL WHERE RANK = 1 AND USERNAME IN ('username1','username2','...','usernameX');

Note: The SQL query provided above generates an enhanced SOD report containing detailed parent role, entitlement owner, and function information.

References: None

Conclusion: By utilizing the enhanced SQL query provided in this solution, users can generate a more informative SOD report that includes details about parent role conflicts, function associations, entitlement owners, and more. This enhanced report aids in better understanding SOD violations and their underlying causes, contributing to more effective remediation strategies.

Version history
Last update:
‎09/08/2023 06:38 AM
Updated by: