How can I find out how many incident does not have outage ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 06:49 AM
Hello All.
How can I find out how many incident does not have outage ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 06:57 AM - edited 05-28-2024 06:58 AM
You should be able to do this with a related list condition in a report (you can then use the resultant query in a script):
Encoded query for any incidents with an outage:
RLQUERYtask_outage.task,>=1,m2m^ENDRLQUERY
You can change the greater than or equal to 1 condition to "none".
Encoded query:
active=true^RLQUERYtask_outage.task,=00,m2m^ENDRLQUERY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 07:06 AM
can you share the screenshot of related list conditions filter ??

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 07:26 AM - edited 05-28-2024 07:27 AM
While you're making your report you have to click on "related list conditions" to expand it, once expanded you can can choose the table (outages) and change matched records to none. You won't need a filter because you are looking for anything unrelated to any outages.
Does that make sense?