How to extract list of Roles/Users causing violations for specific Risk ID or Business Process

[former_member672221]

Dears,

I am looking for way to download the list of Roles causing violations for a specific Risk ID or a Business Process ID or any other condition (if possible).

Currently, if I go to the Dash Board, it shows me the list of violations for a particular BP. But when clicked on it, list of Risks are displayed along with No.Of Violations Column.

If we need to know the list of Roles causing violations against a specific Risk ID, we need to click on a number and again it will open another page with the list of Roles. This process is quite lengthy and time consuming.

May some please tell me how to download the same from back end tables?

Regards

[madhusap · Accepted solution]

Hi Syed,

The ad-hoc and background job results are stored in the GRACSODREPDATA table. However, you cannot retrieve the data using this table as the whole risk analysis report is stored in one field called "REPCONTENT" with different delimiters.

You have to use the program GRAC_EXPORT_REPORT_SPOOL to extract the risk analysis results in tab delimited format using the Report ID.

Regards,

Madhu

[former_member672221 · Accepted solution]

Dear Madhu,

Thanks for your reply. This is just an another way to download the violations report result once performed in Access Risk Analysis path.

This is still good to know 🙂

Regards,

[former_member672221]

Dear Josiane,

Thanks for your reply. What I was looking for was, table(s) to extract the violating Roles or Users from. The method you showed is the standard and at time causing inconvenience to copy the Roles/Users from the Dash Board Reports.

I could find some of the tables clearly like: Role Owner, FF ID Owners etc. But couldnt find any table(s) for downloading the Roles/Users causing violations.

Any input?

Regards

[josiane_costa]

Hello Syed, you can run a Role Level Risk Analysis or a User Level Risk Analysis through path: NWBC -> Access Management -> in Access Risk Analysis choose User Level or Role Level. Then you can run based on Risk ID or run against all your User or Role population. Once you have the results you can Export to Excel and remove duplicates as you wish. Then you will have your unique information. I hope it helps.