Need a Report on Active ( open) RITM's where One or more tasks are OPEN

[Navneet3]

Hi Community Friends.

I need a report on RITMs where one or more task are open. The RITM has multiple tasks associated with it but one task could still be open. 

I found this thread but its not giving me what I need.

https://www.servicenow.com/community/itsm-forum/how-to-create-a-report-on-active-open-ritm-s-where-a...

Thank you for your help in Advanced.

[Harish KM · Accepted solution]

Hi @Navneet3 Create the report on SC_Task table

condition: state is Open

Group By: Request Item

reference

Result:

[Harish KM]

Hi @Navneet3 why don't you run the report on sc task table and dot walk to request item . That way you should get correct result 

[Navneet3]

I did but did not give the results I wanted.

[Harish KM]

Hi @Navneet3 share your condition here

[Navneet3]

Here is what I have.