When I create an Custom SWQL Alert (Advanced) I need to use a base SWQL statement (Select whatever from whereever) but cannot use my own one. Do I have overseen something or is that impossible?
Is it an SQL statement or an SWQL statement you are trying to add? SQL and SWQL are different and don't like each other if you try to mix them.
I'm not sure which version of SolarWinds you are using, but older versions have two radial buttons at the top of the scripting box. If you are running an SQL query, click SQL. If you are running an SWQL query, click SWQL.
You can test your queries you write as well. Type the query and test it
Hi,
it is SWQL query in the actual version. The problem is that you can only use predefined select statements and you can only reduce the amount of rows being selected by a "Where" statement:
The "Select" part cannot be changed
In order of likelihood that you need to do it:Where statementsJoin statements
Join a subquery
(in the white box underneath)
