question Report on Requests with no associated requested items or catalog tasks in ITSM forum

Report on Requests with no associated requested items or catalog tasks

Alex Saager1 — Wed, 03 Jan 2024 12:27:49 GMT

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,

Re: Report on Requests with no associated requested items or catalog tasks

Maik Skoddow — Wed, 03 Jan 2024 12:34:24 GMT

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

Re: Report on Requests with no associated requested items or catalog tasks

Dr Atul G- LNG — Wed, 03 Jan 2024 12:38:55 GMT

Hi @Alex Saager1

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