RIsk, Issue and Decision Report creation

[rdskn023ET]

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!

[Saurav11]

Hello,

Please check the below thread for the same:-

https://www.servicenow.com/community/spm-forum/report-to-show-all-project-risks-issues-decisions-act...

Please mark my answer as correct based on Impact.

[rdskn023ET]

Hi Saurav11.

I have seen this thread and it mentions using RIDAC and as well as the dashboards. Currently, we do not implement anything with RIDAC as an organization and the report we need is for upper level management, which needs to be a printed or emailed report that contains information for all risks, issues and decisions. This is why I was thinking of using a database join to get them all connected but I can't seem to get any data from the join. Does anyone know if you need to use a left join and/or what parameters would the join need to get the data successfully? Thanks!

[Saurav11]

Hello,

Can you show the screenshot configuration of your database join for the tables it would be easier to assist you.

Thanks.

[rdskn023ET]

I have recently started over, so I just have the basics right now.