---
original_url: "https://jace.pro/blog/advanced-reported-with-related-list-conditions/"
format: markdown
ai_optimized: true
---

Advanced Reported with Related List Conditions# Advanced Reported with Related List Conditions

March 20, 2019 [servicenow ](/tags/servicenow/)[reporting](/tags/reporting/)

  Enable AI AnimationThe other day I was asked, “Hey, how can I find all the access controls with NO related roles?”

Reporting on the lack of something is really tough (generally). In this case though Related List Condition queries shine. You can access them in the report interface on ServiceNow.

RequirementSuggested ApproachCIs with more than 1 Active IncidentRelated List ConditionCIs with no outages last monthRelated List ConditionActive Incidents with No Active TasksRelated List ConditionIncidents assigned to a managerRelated List Condition * / Scripted Filter + Dynamic Filter OptionUsers in my assignment groups with no active incidents assigned to themScripted Filter + Dynamic Filter Option
---
[View this page on GitHub](https://github.com/jacebenson/jace.pro/tree/main/./src/posts/2019/2019-03-20-advanced-reported-with-related-list-conditions.md).

[Advanced Reported with Related List Conditions](https://jace.pro/blog/advanced-reported-with-related-list-conditions/) [Jace Benson](https://jace.pro) ![Jace Benson](https://jace.pro/icon-512x512.png)

---

*This content is from Jace Benson's ServiceNow and tech blog at jace.pro*
*Original post: https://jace.pro/blog/advanced-reported-with-related-list-conditions/*