3 Replies Latest reply on Dec 9, 2019 4:23 PM by serena

    Custom SWQL Query of Active Alert filter out "unmanaged"


      I have adapted one of the custom alert queries I found here and was able to edit it to my needs and get it work. However I am stuck on one piece and I hope to get some help.

      I have a Where Clause that will filter out alert that I do not want to see "where o.AlertConfigurations.Name not like 'alert I don't want to see'"


      Where I am stuck is it still returns alerts on node that have been unmanaged. Can anyone assist me with the logic on a Where Clause to filter out nodes that have been unmanaged? if that is possible.


      Or does the filter to show only managed Node exist some where else in these queries?