Report on Requests with no associated requested items or catalog tasks

Alex Saager1
Tera Contributor

‎01-03-2024 04:27 AM

Hi,

 

I've come across an issue where someone has done some work with an API (I think) to try and convert a incidents to a request, this has since been turned off and will be revisited later but for now this has then had a knock on effect of now having requests in the system with no associated requested items or catalog tasks.

 

I've tried working with this link Add related list conditions (servicenow.com) but to no avail

 

Is there an easy way to report on all active requests with no requested item or catalog task associated with it?

 

Many thanks,

0 Helpfuls
  • 690 Views
2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

‎01-03-2024 04:34 AM

Hi @Alex Saager1 

the idea was good. You still can use related list conditions in reports or you follow my instructions in my article Bring back Related List Conditions

Maik

Dr Atul G- LNG
Tera Patron
Tera Patron

‎01-03-2024 04:38 AM

Hi @Alex Saager1 

 

Can not we check the reverse, if any sctask has not parent attached?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls