ServiceNow Report issue in Zurich

[deborahdorr]

Hi,

I am trying to build a report that allows me to see RITMs that are open that has ALL associated Tasks marked closed. We tried to do with a database view, using the regular filtering in building a report. The only thing that worked was adding a field to the Requested Item table (sc_req_item) that is using a scheduled script to run every 4 and checks if all associated tasks to that RITM are closed. If they are all closed, it shows in a column as true and if there is at least 1 still open it says false. We do not want to add a custom field to the sc_req_item unless we absolutely have to. Does anyone have any other workarounds that we may have missed that can filter what we need?

#zurich #platformanalytics #reporting #dashboards

[Tanushree Maiti]

Hi @deborahdorr 

1. Create a report on the sc_req_item table.

Set the filter condition to:

• State Is Open

Then apply a Related List Condition for Catalog Task and choose the appropriate task state like Closed Complete/Closed Incomplete, Closed Skipped etc

2.By Fix script you can get all Open RITM List with all closed tasks

Report of open RITMs with all closed tasks 

[AndersBGS]

Hi @deborahdorr 

You could create a report based on RITM table with related list condition where related sc_task = 0. This would be the most clean way to build the report.