Finding all RITMs with no active TASKs

[Gaetano Ferrara]

I need to create a report to find all RITMs (parent) that contain no active TASKs (child).

I know how to get information about a parent from a child by using things like "Parent.Updated", but not the other way.

Is there something like that I can use like "Child.Active" and then check for True/False?

[Ankur Bawiskar]

Hi,

you can have database view joining both the tables i.e. sc_req_item and sc_task with the sql query as active is true

something similar to this

once you create a database view you can have a report on this database view table i.e. u_task_and_ritm

How to create database view -> https://docs.servicenow.com/bundle/jakarta-performance-analytics-and-reporting/page/use/reporting/task/c_CreatingDatabaseViews.html

How to create report -> https://docs.servicenow.com/bundle/helsinki-performance-analytics-and-reporting/page/use/reporting/task/t_CreateYourOwnReport.html

screenshot 1: where clause -> ritm_sys_id = sctask_request_item && (sctask_active != 1)

after capturing this click on Try It and it would show those RITMs which are having sc task records as false

view table sc_task view fields screenshot

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[ZaheerBk]

Hi Ankur,

Am looking something similar but with little bit of a tweak

My Requirement is to ''Finding all RITMs with no TASKs Generated'' ( it means during some of the workflow issues or any issues which impacts workflow, post successful Approval step, as part of fulillment, catalog tasks are not generated at all )

I need to find, how can we do this with report or with DB views, i need to get the list of impacted services through RITMs or REQs.

Kindly share me your expertise on the same.

Many Thanks

Zaheer

[Adam Stout · Accepted solution]

This should be straight forward with a Related List Condition.  I don't see what you would need a view for this.

[Gaetano Ferrara]

I'm going to look into these options but I'm not sure if we have them activated, thanks!