Advanced Reported with Related List Conditions

The 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 Approach
CIs with more than 1 Active IncidentRelated List Condition
CIs with no outages last monthRelated List Condition
Active Incidents with No Active TasksRelated List Condition
Incidents assigned to a managerRelated List Condition * / Scripted Filter + Dynamic Filter Option
Users in my assignment groups with no active incidents assigned to themScripted Filter + Dynamic Filter Option