Show an Issue's Remediation Tasks/Action Plan (Along with Due Date and Owner) in the Issue List View

[prashant_a_]

In IRM issue management module, I'm trying to produce what is essentially an issue register that extends down to remediation tasks (action plan to address the issues)  - i.e., each issue shown together with all of its remediation tasks/action plan in one consolidated list. The challenge is the data spans two tables: issues is sn_grc_issue and  remediation task/action plan detail sit in sn_grc_task

What I want to achieve in one view, per issue: 

• The Parent issue along with issue #, name, owner, due date
• The remediation task ( # of task can be 2, 3, 4, 5 and so on for each issue) #along with task due date and task owners.

My Questions: 

• Does ServiceNow IRM (Zurich) support displaying an issue and all of its related remediation tasks in one list view, (one row per issues with all of its remediation tasks), given that data spans two tables? 
• If yes, what's the recommended approach  - a database view joining the two tables, a related list, a report grouped by issue/remediation task, or something else? 
• Is there anything closer to this available out of box in Zurich before I look at customization? I'd have expected a consolidated issue register view like this to be fairly standard and common or rather basic/fundamental feature in any GRC tool. 

Environment - ServiceNow IRM, Zurich release. Tables: sn_grc_issue, sn_grc_task.

Thanks in advance

[Tanushree Maiti]

Hi @prashant_a_ 

Try this 

Navigate to System Definition > Database Views.

 Click New to create a new view (like, x_sn_grc_issue_register).

 Add the following records to the View Tables related list:

• Table 1: sn_grc_issue (Prefix: gi)
• Table 2: sn_grc_task (Prefix: gt)

 In the gt (Table 2) record, set the Where clause to:
gi_number = gt_issue  

Also try with this one if above one does not work

gi_sys_id = gt_issue