Report on Risk Assessment answers from Change Reqeust records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-27-2023 12:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2025 01:57 PM
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:
- [change_request]
- [asmt_assessment_instance_question]
- chg_sys_id = aiq_source_id
- [asmt_metric]
- aiq_metric = asmt_sys_id
- [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!