Report on Risk Assessment answers from Change Reqeust records

[daniel milea]

I need to create a report that gives me the answers to the Risk Assessments on Change Requests.
I found a similar question posted a while back but the answer no longer applies , I don't have the possibility to create a database view , so I will need to do this manually .

I have found the asmt_metric_result table thatn contains the answers when I cannot see a way to map it backwards to the change record.

Thanks in advance 

[hgghg]

Hello @daniel milea 

Idk if you are still looking for the answer but I found a solution for this kind of request. 

You need to join the following tables:

1. [change_request]
2. [asmt_assessment_instance_question]
   • chg_sys_id = aiq_source_id
3. [asmt_metric]
   • aiq_metric = asmt_sys_id
4. [asmt_metric_result]
   • asmt_sys_id = asmtr_metric & aiq_instance_= asmtr_instance

Hope it works for you, if you have any questions please contact me. 

- Sorry for not attaching a screenshot of the example, but I did it in SQL. Anyway, following those instructions you can create it in a database view without any problem.

Thanks!