Need help finding or creating reports on multiple RITMs linked to a single REQ.

[sk56]

Need help finding or creating reports on multiple RITMs linked to a single REQ.

We have 10000 RITMs, and we need to figure out how many RITMs are linked to each REQ.

Any script or report would help.

Thanks

[AndersBGS]

Hi @sk56 ,

Just create a report based on the sc_req_item. Here you will be able to group by request to get the count.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[sk56]

Hi AndersBGS

On report, we need to get only those REQ who has more than 1 RITM.

each request is linked to multiple RITM.

thanks 

[Community Alums]

Hi @sk56 ,

If you want the report of Requests on sc_req_item. Right click on header of Requests of sc_req_item table and select Bar/ Pie chart it will genrate the report like below image 

Result 

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak