SQL query filter

Try:

SysName not like '*sql*' OR  not like "*node*" OR not like "*db"

I think I lied, try this:

SysName not like '*sql*' OR SysName not like "*node*" OR SysName not like "*db"

I just tried that and it came back with

Custom SQL filter is incorrectly formatted.

what version is your NPM, mfoley@homesite.com‌?

11.5.2

OK, sometimes double quotes are evil try:

SysName not like '*sql*' OR SysName not like '*node*' OR SysName not like '*db'

And this did work for me.

I just tried this and it didn't seem to remove any of the items I specified in the query. If i just choose say one item like '*node*' it works but it seems if i add more than one it doesn't like it.

Replace the OR with AND

I think you want things that do not match any of the three criteria, which needs AND

SysName not like '*sql*' AND SysName not like '*node*' AND SysName not like '*db'

OK since there had been some changes in the tables, why not try this one:

NodesData.SysName not like '*sql*'

Also make sure the Type of View is set to Summary just like what's in here:

JM that worked.. The AND did the trick!  Thanks everyone for the help on this.