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?