ServiceNow Report issue in Zurich
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
39m ago
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
