Report For All Open RITM Tickets

[msekla]

How do I create a report in ServiceNow to give me all open RITM tickets where all their associated TASK tickets are closed. I don't even know where to start because I have never created something like this before therefore I don't have a screenshot on the part I am stuck on. Please give me a full step-by-step on how I can accomplish this. Thanks

[Dr Atul G- LNG]

Hi @msekla 

If  I speak from OOTB side, once all task closed for a REQ, the RITM and REQ moved to closed automatically. In your report it will be zero.

or you want 

to see RITM , where task as still open.

[Dr Atul G- LNG]

Hi @msekla 

You can create report :

https://youtu.be/BCUJZd_KilA

[Andrew_TND]

Hello, thats straight forward.

Just follow the below steps.
1. Go to Reporting
2. Set the table as sc_req_item
3. In the condition builder use the below logic - 

Update both conditions so active=true,

If your workflows arent closing the RITMS so the active is falso update the table condition to include inactive states such as, closed complete, closed incomplete, cancelled etc etc.

Please mark as helpful or if its resolved your issue, correct!

[swathisarang98]

Hi @msekla ,

With this you will get all the RITM details along with SC task detail aswell.

You can navigate Reports -> Create New

In Data section please select as below,

Name :

Source Type : Table

Table: sc_task

and for rest please refer the below screenshot,

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang