SWQL Syntax: List of SWQL (NOT SQL) Arithmetic Operators, Keywords and Logic Operators

We have this documentation of functions, https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions, but never seen any for the operators.  As far as I can tell it supports everything you can do in SQL server.

https://www.w3schools.com/sql/sql_wildcards.asp although I admin I have never tried the bracket stuff, but I use % and _ in a million ways every day.  Like, not like, in, between, etc.

I also just realized a good way to validate a syntax is just to run SWQL studio as it's syntax suggestions seem to contain all available functions as well.

https://github.com/solarwinds/OrionSDK/releases  In hindsight I probably learned all the quirks of SWQL that I know from trying things out in there.

We have this documentation of functions, https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions, but never seen any for the operators.  As far as I can tell it supports everything you can do in SQL server.

https://www.w3schools.com/sql/sql_wildcards.asp although I admin I have never tried the bracket stuff, but I use % and _ in a million ways every day.  Like, not like, in, between, etc.

I also just realized a good way to validate a syntax is just to run SWQL studio as it's syntax suggestions seem to contain all available functions as well.

https://github.com/solarwinds/OrionSDK/releases  In hindsight I probably learned all the quirks of SWQL that I know from trying things out in there.

Thinking on the main limitations I have found in SWQL versus SQL Server is there aren't window functions, you can't declare variables or create temp tables or execute stored procedures, although the verbs pretty much are a window into the native sprocs.

Thanks mesverrum...  I did try the "NOT LIKE" logic in my SWQL statement but for some reason it didn't like it. I simply assumed it wasn't available, which appears to be my mistake.  I'll try again this morning and get back to you.

...and I found out what I was doing but not what the problem is.   I was trying to modify the "Edit Resource: Top XX Interfaces by Percent Utilization" on the Network Top 10 default dashboard.   

I'm unclear if this area takes the full SWQL statement or just a portion that is relevant.   For example, in SWQL Studio, this statement produces what I want without error:

SELECT Caption from Orion.NPM.Interfaces WHERE Caption NOT LIKE '%Tunnel%'

However, since I have to assume it's only going to pick interfaces anyway under the "filter interface" box, I tried this:

Caption NOT LIKE '%Tunnel%'

...and it doesn't like that at all.  When I examine the result on the Network Top 10 dashboard, that widget simply tells me:

Help me, Obi Wan mseverrum, you're my only hope! 

You need to use the following as the resource doesn't know whether you are looking at Node or Interfaces caption. Also take note that some of the widgets used SWQL and some use SQL filters to the syntax may change. 

Interfaces.Caption NOT LIKE '%Tunnel%'

If you wanted to filter by node caption you would use:

Nodes.Caption NOT LIKE '%SW45%'

The SWQL/SQL format also changes how you reference custom properties:

SQL: Interfaces.Comments = 'Blah'

SWQL: Interfaces.CustomProperties.Comments = 'Blah'

Thank you shuth!!  That worked perfectly.