Report of all RITMs and their associated tasks

[RahulPeddinti]

I have multiple open RITM's, where I need to fetch tha status of their associated child RItms status in a report, (i can't say the child ritm's will be only having 'task' they have 'change' as well and might be other tasks)

[Aditya_hublikar]

Hello @RahulPeddinti ,

If you want to show ritm and their related sc task then database view is simple for this.Then use that databse view table in your reports and add their relevant aggregation in reports .

If child is other than task then you have to created database view according to you requirement .

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya

[SohamTipnis]

Hi @RahulPeddinti,

Yeah, so the issue here is you’re trying to report on child records of different types (tasks, changes, etc.) under a single RITM, and ServiceNow doesn’t naturally give you one clean field for that.

If all your child records are properly linked to the RITM (like via Request Item), you can try reporting on the Task table, since most records extend from it. That way you can at least see all related records together.

But in reality, changes and other records are often linked differently, so reports start getting messy or incomplete.

The practical way people handle this is:
1. Create a custom field on the RITM (like “Child Status"). 
2. use a Business Rule or Flow to check all child records
3. update that field based on their states (e.g., if any open → In Progress, all closed → Completed)

Then your report becomes super simple because everything is already summarized on the RITM.

You can try reporting directly, but the clean and reliable way is to roll up the child status onto the RITM and report on that. 👍

Let me know if this works!!!!!😉

If you find my answer useful, please mark it as Helpful and Correct. ‌‌😊

Regards,
Soham Tipnis
ServiceNow Developer || Technical Consultant
LinkedIn: www.linkedin.com/in/sohamtipnis10

[RahulPeddinti]

I thank all the above who came to support I did the report by using TASK table which is a parent table of all extended tables so I filtered records parent contains RITM and chose parent column as a group by then I have given my RITMs as a static for check I got the output