paul326

Figured it out... was adding the 'where' statement in the wrong place. Added it to the LEFT OUTER statement and all good where N.Caption NOT LIKE 'TST%' Paul

This is excellent stuff, especially since I'm a n00b with SQL queries. I've been trying to add line to exclude specific N.Caption names to exclude nodes we don't want reported (items to manage but not alert, 100% of the time muted) This query gets me exactly what I need except excluding caption name that contains 'TST' Any…