Reporting using multiple Related List Conditions

[MStritt]

Hello,

On our Account form, we have multiple Related Lists. I want to run a report, that will show me all Active Accounts that have no records for the Related Lists highlighted below (Contacts, Assets, Contracts, Entitlements).When creating the report, it looks like you can only query on 1 Related List condition. Is there a way to query multiple Related Lists?

[Adam Stout]

Reports only support one Related List Conditions at a time.  If you need to do more, you have to look at a scripted filter.  Here are some examples:  https://community.servicenow.com/community?id=community_blog&sys_id=bd0eaa2ddbd0dbc01dcaf3231f96199e

[MStritt]

Thanks Adam.

Unfortunately, I don't have a lot of experience with scripting. Anyway you can provide assistance, on how I would need to configure the script (script include) for my use case?

[SusanWinKY]

Is there any possibilty this will be added to the UI?

Our use case: We want to see all Incidents and Change Requests that have an Affected CI or an Impacted CI that is "Used for" Manufacturing. 

[Michael Kaufman]

Here is a scripted filter for your use case.  I had to do something similar recently.

https://www.servicenowelite.com/blog/2019/10/8/unprocessed-accounts