RAR Risks assigned to Risk Owners

[Former Member]

Hi,

After assigning Risk Owners to Risks in RAR, is there an easy way to find which Risks are assigned to Risk Owners?

Only screen I have found which has Risk Owner as a selection criteria is under Alert Monitoring.

Thanks,

Stephen

[Former Member · Accepted solution]

Hi Stephen,

You could check that by running a query against table VIRSA_CC_RISKOWN.

Hope it helps. Regards,

Imanol

[Former Member · Accepted solution]

Thanks Imanol,

I assume I need to write an SQL in the CCDebuuger in order to get the data - I am not real good on SQL but could try.

I was hoping there was an existing report which I had missed as the person I am handing over to is not a techo, so if it cannot be obtained from within the RAR tool, then I probably wouldn't want him in the CCDebuuger.

Regards,

Stephen

[Former Member · Accepted solution]

Hello Stephen,

Here is an alternative way:

1. Rule Architect --> Utilities --> Export

2. Select "Risks" (unfortunately BP, BF and Ruleset will also by default be selected)

3. Click "Get Rules"

4. Click "Export Rules," save the text file to Desktop

5. Open the text file with MS Excel.

6. Filter column B entries that have the text "VIRSA_CC_RISKOWN"

-Dylan

[Former Member · Accepted solution]

Thanks Dylan - that is a great solution. Easy for a non-techo to follow & gives the required information.

Much appreciated.

Regards,

Stephen

[Former Member]

Less tech solution

Great Dylan, great!!