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

[harishdasari]

Hi Luca,

I am thinking that it should be issue with where clause in tables.

relate these 2 tables with a common field something like this

example:   chg_parent = inc_sys_id

Thanks

[jj_lyk]

Hi Harish,

thanks for the information provided and I agree with you on logical approach.

Actually I've the following situation:

• joined tables (sn_compliance_control and asmt_metric_result ) --> let's say A
• sn_risk_risk --> let's say B

On Risk (sn_risk_risk), I can associate controls (sn_compliance_control ) and controls can be evaluated (asmt_metric_result).

With A, I've gather all informations about controls and their evaluations and I would find their risk associated.

So, since in Risk form there's a related list out of the box named Controls (that associate controls to risk) I would find which "core" field is supposed to be used in order to perform the association i.e ( Risk.sys_id = Control.sys_id).

Do you have any ideas on this?

[harishdasari]

Hi David

could you please help Luca on her requirement and I exited to know how to accomplish this requirement.

david-smith

Thanks

[Dave Smith1]

Information about Database views can be found here: Database views

However,

Since I'm able to "join" sn_compliance_control (sys_id) with asmt_metric_result (source_id) 

Although you can join them... what is it you're attempting to achieve here?   You seem to be describing issues with your intended journey, but not actually clarified what your desired destination is.