Relations between sn_risk_risk , sn_compliance_control and asmt_metric_result

[jj_lyk]

Hi all,

I'm figuring out to create a db view between tables above in the subject in order to show all the sn_risk_risk entries with their controls associated and with their control attestation scores.

Since I'm able to "join" sn_compliance_control (sys_id) with asmt_metric_result (source_id) in order to get all controls with their results, I'm encountering some difficulties to related this joined table with sn_risk_risk

Hoping someone can helping with this.

Br,

Luca

[jj_lyk]

Hi Dave,

I would get risks with associated controls and their attestation scores in my database view.

I'm looking for the field inside risk (sn_risk_risk) that can be used to join the control associate in (sn_compliance_control)

Br,

Luca

[Dave Smith1]

As a matter of interest - are you doing this to create a report? Or expose the data on a dashboard somewhere?

[jj_lyk]

No, I need to write a sort of script in order sum controls evaluations.

I've used a database view, instead of background,   'couse it provides a nicer way to show results.

BTW, I think I've found where informations are stored --> sn_risk_m2m_risk_control

Now I'm gonna try to keep results, finger crossed