Report on Risk Assessment answers from Change Reqeust records

daniel milea
Mega Contributor

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 

1 REPLY 1

hgghg
Tera Contributor

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!