RIsk, Issue and Decision Report creation

rdskn023ET
Tera Contributor

‎11-01-2022 10:12 AM

We have been asked to create a report that will display the Risks, Issues and Decisions for Programs in ServiceNow. Being there are several different tables involved, I assume a database JOIN will need to be used. We do not use the RIDAC option, so the JOIN is the only thing I can think of to get this data. Has anyone done this before or have an example of the database JOIN with any additional parameters that need to be used or have any alternate ideas on how to get this information into a report for upper level management? Thanks!

0 Helpfuls
  • 778 Views
5 REPLIES 5

Saurav11
Kilo Patron
Kilo Patron
In response to rdskn023ET

‎11-02-2022 07:37 AM - edited ‎11-02-2022 07:38 AM

hello,

 

I see so you don't use RIDAC yet so that means risk, issue and decision are not linked with each other and they all are separate entity? is that the case? So i don't think you will be able to get the 

database view configured.

Without them being linked the closest thing I can think of is to create a report on task table and apply filter task type is issue or task type is decision you will get all the issue and decision in one report . unfortunately you cannot get risk as risk does not come under task table(At least in m PDI is doe not show you can check on your instance)

 

Saurav11_0-1667399827801.png

 

Please mark my answer as correct based on Impact.

0 Helpfuls